Online Documentation for SQL Manager for PostgreSQL

Restore Database

Restore Database Wizard allows you to perform the database restore operation on your PostgreSQL system (with the pg_restore utility of PostgreSQL server used).

This operation is used to rebuild a damaged or corrupted database that has been backed up using Backup Database Wizard. You can restore the backup copy to an existing database, or create a new database and restore the backup copy into the newly created database.

To run the wizard, select the Services | Restore Database... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | Restore Database... item of the context menu. Alternatively, you can right-click the host alias and select the Tasks | Restore Database... context menu item.

• Selecting host
• Selecting source file for restoring
• Selecting restore type
• Setting restore options for database objects
• Selecting objects to restore
• Setting additional restore options
• Running database restore