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
|
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. |
|
|
See also: |
