How to restore a PostgreSQL backup


There would seem to be several ways, but if the backup file was created by pg_dump and is actually a series of DDL and INSERT statements, then use:

psql -U postgres -d dbname < dbname.backup

‘Nuff said!

August 22, 2014 postgres