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...