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 and then select either Perform complete instance recovery or Perform point in time recovery.

   Note:

   Point in time recovery option is only available for incremental backup.

   Perform point in time recovery:

   • On the Recovery option window, select one of the following:

     • Recovery point selected for the default recovery point.

     • Point in time and then select exact date and time for recovery.

       Note:

       Select the point in time which is post the previous full backup and includes a time through selected incremental recovery point.

7. Click the search icon in the Host field, select the desired host and click Save.

   • If the recovery is to an alternate host, then select the corresponding valid credentials from the displayed list.

   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 the specified alternate location. The folder structure of the restored data within the alternate location is the same as the original data that is same folder and subfolder setup.

     • Directory for Restore - PostgreSQL full backup data is restored to the specified path.

     • Write Ahead logging Directory - PostgreSQL WAL files are restored in this directory. PostgreSQL incremental backup data is restored to the specified path.

   Note:

   If the instance is added manually and not discovered automatically, then only Restore everything to a different location option can be selected.

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 or Restore and recovery option to perform instances and database restore and recovery:

    Note:

    For point in time recovery, Restore and recovery option is triggered automatically.

    • Restore: Restores the instances.

    • Restore and recovery - Recover the instances.

    Note:

    For LVM and VSS if the Restore and recovery option is selected, then contents of the target data directory is deleted by recovery operation.

    Note:

    In the Restore and recovery option, the PostgreSQL service must be up and running. If the service is stopped, the restore will fail.

    The data folder must be empty to run the Restore option on the same path. If the folder is not empty, then, the data will not restored.

13. Click Next.
14. On the Review tab, review the details and click Start recovery.