Postgresql – migrate a database

Dump source database:

pg_dump -C -h hostname -U postgres databse > database.sql

Load the structure into the new database:

psql -U postgres -d database -f database.sql