LedgerSMB
Restore From Backup
The following command restores a database using the backup file created through the LedgerSMB front-end:
$ pg_restore -d dbasename filename.sqlc
Note: If you're restoring over an existing database, it's a good idea to create a full backup of the entire database before attempting any restore, ideally using the pg_dump utility.
-- Frank Dean - 10 May 2012