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 | iconServices_RestoreDatabase Restore Database... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | iconServices_RestoreDatabase Restore Database... item of the context menu. Alternatively, you can right-click the host alias and select the Tasks | iconServices_RestoreDatabase Restore Database... context menu item.

 

menuRestoreDatabase

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.