Restore Database

Restore Database (Restore icon) is used in the unfortunate (and unlikely) event that the database has been damaged and needs to be restored from a backup archive file. This feature allows a convenient way to perform a basic restore operation using the PostgreSQL built-in pg_restore utility. The recommended procedure is to do a full restore (Database drop and replace option) along with an Analyze operation. There are a number of other options and alternative approaches to restoring a database which are fairly involved and require multistep operations. These may be best handled using a system administrator interface such as pgAdmin III or PG Lightning Admin.

The Database Recovery Wizard

Selecting Restore Database opens a wizard page with nine options. Complete and review these options carefully, then click Finish to start the restore operation.