Restore PostgreSQL instance and database
You can restore a PostgreSQL instance or database either to an original backup location or to an alternate location. You can choose to recover from the default copy of the instance or database. The default copy is also known as the primary copy.
To restore a PostgreSQL instance
- On the left, click Workloads > PostgreSQL.
- On the Instances tab, select the instance that you want to recover.
- Click Recover from the top bar.
- 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.
- 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.
- 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.
- 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.
- 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.
Note:
WAL files will be restored in the data directory when Restore option is selected, whereas, in case of Restore and Recovery, WAL files will be restored to path mentioned in WAL directory for restore option.
- Click Next and follow the instructions prompted.
- On the Recovery source tab, review the storage details.
- Click Next.
- 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.
- Click Next.
- On the Review tab, review the details and click Start recovery.
To restore a PostgreSQL database
- On the left, click Workloads > PostgreSQL.
- On the Databases tab, select the database that you want to recover.
- Click Recover from the top bar.
- 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.
- 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.
- Click Actions > Perform complete database recovery.
- Click the search icon in the Host field, select the desired host and click Save.
If the recovery is to alternate a host, then select the corresponding valid credentials from the displayed list.
For more information, See Restore target options.
- 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 the alternative location which you can specify. 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 - The PostgreSQL data directory. 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.
For more information, See Restore target options.
- Click Next.
- On the Recovery source tab, review the storage details.
- Click Next.
- On the Recovery points tab, select the Restore or Restore and recovery option to perform instances and database restore and recovery:
Restore - Restores the database.
Restore and recovery - Recovers the database.
- Click Next.
- On the Review tab, review the details. For any changes you can edit the recovery target, recovery source and recovery options or click Start recovery.