# Postgres database restore via dumps

Create the database dump (you'll be prompted for the password)

`pg_dump -U<DB_USER> -h<DB_HOST> <DB_NAME> > dumpfile`

Copy over the dump file to the new machine that has postgresql installed

Recreate the DB or drop individual tables

Apply the dump

`psql -U<DB_USER> -h<DB_HOST> -d <DB_NAME> < dumpfile`

> The dumpfile might need to be altered to be ingested into a higher versioned DB