How do I restore my data?

Assuming you have created a backup file using setup.pl or the following command on the command line (which is the command line equivalent of what setup.pl does):

 $ pg_dump -F c -f your_backup.bak your_company_database

 

You can restore your database using the command:

 $ pg_restore [options] your_backup.bak

If you want to restore into a new database, replace [options] with -C new_database. If you want to restore and replace an existing database, replace [options] with --clean -C new_database.

Note: You need to restore the roles backup before restoring the data backup.

Release: 
FAQ Category: