7,649
edits
Changes
Jump to navigation
Jump to search
→Dumping and Restoring a Database
To reload this database:
pg_restore -d DBName db.backup
We typically use compression (Postgres' format custom), so the best command is:
pg_dump -Fc dbase > dbase_fc.dump
pg_restore -Fc -d DBName db.backup
All backups are stored in /bulk/backups. You can drop a database after it has been dumped with:
dropdb dbase
To selectively restore a single table use the -t tablename option. See https://www.postgresql.org/docs/9.2/static/app-pgrestore.html for the other options.
==SQL Commands==
