Database Restore (PostgreSQL)
Go Up to Database Recover/Restore
This wizard lets you generate and submit a pg_restore utility operation, restoring one or more tables or views of a database from a previous backup.
- Note: For information on generating a pg_dump backup script, see Database Backup (PostgreSQL).
To restore a database from backup
- Connect to the datasource where the database to be restored is located and ensure that it is the currently selected datasource. For details, see Connected/Selected Datasource options.
- Select Utilities > Database Restore to open the Restore Wizard.
- Use the following table as a guide to performing tasks as you pass through the wizard panels:
Panel | Option | Description |
---|---|---|
Playback |
New Backup Operation |
Select to define a new backup operation. |
Previous Backup Operation |
Lets you specify a previously saved operation. | |
Datasource and Input options |
What are the destination datasource and database |
Lets you specify the specific datasource and database where the tables and views in the backup script are to be restored.. |
Specify the format for the data file(s) to be generated |
Lets you specify a -F (--format) archive format option of Custom or Tar or Directory. | |
Number of jobs |
Lets you provide a --j (--jobs) option value, specifing that the most time-consuming parts of the restore run as separate, concurrent jobs. | |
Rolename |
Lets you provide a --role option value, specify the role used to perform the restore. | |
Files |
Specify the data input file to be restored, Specify a path for the message file to be generated, and Do you wish to re-use this restore operation |
These settings lets you select the archive file used for the restore, specify the paths for the message file, and specify the path for the optional file that lets you reuse the current backup operation. |
Options |
Sections |
Lets you provide one or more --section option values ( Pre-data. Data, Post-data) specifying that the selected sections are restored. |
Type of Objects |
Only data - corresponds to a -a (--data-only) option, specifying that only data be restored. Only schema - corresponds to a -s (--schema-only) option, specifying that only object definitions be restored. | |
Don’t save |
Owner- corresponds to a -O (--no-owner) option, specifying no output commands to set ownership of objects to match the original database. Privilege - corresponds to a -X (--no-privileges) option, preventing restoration of access privileges. Tablespace - corresponds to a --no-tablespaces) option, specifying no output commands to select tablespaces. | |
Queries |
Include CREATE DATABASE statement - corresponds to a -C (--create) option, specifying that the database be created before restoring into it. Clean before restore - corresponds to a -C (--clean) option, specifying that the commands to drop objects are specified before commands to create them.. Use Column Inserts - corresponds to a --column-inserts option, specifying that data is dumped as INSERT commands with explicit column names Single transaction - corresponds to a -1 (--single-transaction) option, specifying that the restore be executed as a single transaction. | |
Miscellaneous |
Use SET SESSION AUTHORIZATION - corresponds to a --use-set-session-authorization option, specifying that object ownership is determined using SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands. Exit on error - corresponds to a --exit-on-erroroption, specifying that the restore is aborted if an error is encountered. Verbose messages - corresponds to a --verbose option, specifying that verbose mode be used. | |
Objects |
Use the object list to select each specific object that is to be restored. The Schema dropdown can be used to reduce the number of objects displayed to only those objects within a selected schema. | |
Summary |
Provides a short summary of the dump operation options. |
- 4. Finally, use the Finish button to perform the backup.