You can restore the following data from a DumpBased backup set:
-
Individual databases
-
Individual database tables
You can restore to the same instance where you performed the backup, a new instance on the same backup client, or a client that is different from the backup client.
Before You Begin
-
Verify that the PostgreSQL software version on the destination is the same version or higher than the version of the source.
-
You must create an instance or cluster instance (If it is a cluster restore) on the destination client before initiating an out of place restore.
-
For a DumpBased backup set, do the following:
-
The pg_dump does not include cluster-wide role information. To back up roles and other global objects, use pg_dumpall utility or Enable backups for global objects in the database.
-
If global objects are backed up, roles are restored automatically on clients running version 11.36.53 or later. On earlier versions, create the required roles on the destination before starting the restore.
-
The restore creates only roles that are missing on the destination; it does not recreate roles that already exist.
-
To prevent the restore from recreating roles or preserving their original ownership,, set additional setting bRestoreRolesFromGlobalFile.
-
If you did not back up the global objects and want to restore the data with the database user specified in the destination instance properties to own the restored data, create the additional settings bPGRestoreNoACL and bPGRestoreNoOwner before initiating the restore job.
-
To restore maintenance database, modify the maintenance database in the Instance details page to another database that will not be a part of the restore job.
-
The source computer and destination computer should have the same operating system.
-
Enter an optimal value for the number of parallel jobs based on the hardware setup of the server, client, and network. For more information, go to the -j command line argument in the PostgreSQL documentation website
-
Procedure
-
From the Command Center navigation pane, go to Protect > Databases.
The database Overview page appears.
-
Go to the Instances tab.
-
click the instance you want to restore, and then in the Recovery points, click Restore.
Alternatively, in the row for the instance, click the action button
, and then click Restore.The instance Overview page appears.
-
In the Recovery points calendar tile, select DumpBasedBackupSet.
-
Select a date from the calendar, and then click Restore.
The Backup content page appears.
Note
Ensure that you have performed a successful backup on the selected date.
-
From the Database view drop-down list, you can select the following two views:
-
Database view
-
Table view
-
-
Click Restore.
The Restore options dialog box appears.
-
If you select Database view, you can perform in-place restore and out-of-place restore of PostgreSQL database instance.
-
If you select Table view, you can perform in-place restore and out-of-place restore of Postgresql databases tables.
-
Click Submit.