NetBackup™ Web UI PostgreSQL Administrator's Guide

To restore a PostgreSQL instance:

1. On the left, click Workloads > PostgreSQL.
2. On the Instances tab, select the instance that you want to recover.
3. Click Recover from the top bar.
4. On the Recovery points tab, select the date with available backup.

   Note:

   In the calendar view, dates with available backups are indicated with a green dot.

5. From the listed Backup images/ Recovery points, select the desired image or recovery point.

   Note:

   The backup images or recovery points are listed in rows with the respective backup timestamp.

6. Click Actions > Perform complete instance recovery.
7. Click the search icon in Host field, select the desired host and click Save.

   For more information , See Restore target options.

8. Select the appropriate instance directory path from one of the following options:

   • Restore everything to original location: Files are restored to the location where they were originally backed up from.

   • Restore everything to a different location: Files are restored to alternative location that you can specify. The folder structure of the restored data within the alternate location will be the same as that of the original data that is same folder and sub-folder setup.

   • Restore files to different paths: Files are restored to alternative location that you can specify. All files will be restored to a single folder. The folder structure of the original data is lost. All data from folders and sub-folders are extracted to a single folder instead.

     For more information, See Restore target options.

9. Click Next and follow the instructions prompted.
10. On the Recovery source tab, review the storage details.
11. Click Next.
12. On the Recovery points tab, select the Restore checkbox for instances and database restore.
13. Click Next.
14. On the Review tab, review the details and click Start recovery.

To restore a PostgreSQL database:

1. On the left, click Workloads > PostgreSQL.
2. On the Databases tab, select the database that you want to recover.
3. Click Recover from the top bar.
4. On the Recovery points tab, select the date with available backup.

   Note:

   In the calendar view, dates with available backups are indicated with a green dot.

5. From the listed Backup images/ Recovery points, select the desired image or recovery point.

   Note:

   The backup images or recovery points are listed in rows with the respective backup timestamp.

6. Click Actions > Perform complete database recovery.
7. Click the search icon in Host field, select the desired host and click Save.

   For more information , See Restore target options.

8. Select the appropriate Database directory paths from one of the following options:

   • Restore everything to original location: Files are restored to the location where they were originally backed up from.

   • Restore everything to a different location: Files are restored to alternative location that you can specify. The folder structure of the restored data within the alternate location will be the same as that of the original data that is same folder and sub-folder setup.

   • Restore files to different paths: Files are restored to alternative location that you can specify. All files will be restored to a single folder. The folder structure of the original data is lost. All data from folders and sub-folders are extracted to a single folder instead.

   For more information , See Restore target options.

9. Click Next and follow the instructions prompted.
10. On the Recovery source tab, review the storage details.
11. Click Next.
12. On the Recovery points tab, select the Restore checkbox for instances and database restore.
13. Click Next.
14. On the Review tab, review the details. For any changes you can edit recovery target, recovery source and recovery options or click Start recovery.