Restore PostgreSQL Database Tables and Instances from a Block-Level Backup

You can browse and restore backed up data for an entire database or for individual databases.

Use FSBased backupset, to restore the entire database.

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 FSBasedBackupSet, stop the PostgreSQL server and delete or rename the data directory, user tablespace directory, archive log directory and transaction log directory that is outside the data directory.

  Note

  For FSBased backup set, it is assumed that the data directory path and tablespace location in the source and the destination clients are the same. If they are different, then redirect the data directory to a different path by performing a redirect restore operation.

• For FSBasedBackupSet, the source computer and destination computer should have the same operating system.

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 that you want to restore.

4. In the row for the instance, click the action button , and then click Restore.

   Alternatively, click the instance you want to restore, and then in the Recovery points, click Restore.

   The instance Overview page appears.

5. In the Recovery points calendar tile, select FSBasedBackupSet or DumpBasedBackupSet.

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

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

   1. Database view

   2. Table view

8. Click Restore.

   The Restore options dialog box appears.

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

10. If you select Table view, you can perform in-place restore and out-of-place restore of PostgreSQL database tables

11. Click Submit.