Performing PostgreSQL DumpBased Backup Set Restore Operations

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

• Perform a backup.

• 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:

  • To back up roles and tablespaces in the database or table, enable backups for global objects in the database. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles and tablespaces by default. If you did not have the global objects backed up already, to restore the data with the database user defined in the destination instance properties as the owner, 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.

  • Use parallel jobs to dump the PostgreSQL database.

  • 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

1. From the navigation pane, go to Protect > Databases.

   The database Overview page appears.

2. Go to the Instances tab.

3. 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.

4. In the Recovery points calendar tile, select DumpBasedBackupSet.

5. 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.

6. From the Database view drop-down list, you can select the following two views:

   1. Database view

   2. Table view

7. Click Restore.

   The Restore options dialog box appears.

8. If you select Database view, you can perform in-place restore and out-of-place restore of PostgreSQL database instance.

9. If you select Table view, you can perform in-place restore and out-of-place restore of Postgresql databases tables.

10. Click Submit.