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!