When the PostgreSQL Server is corrupted or lost, you can restore and recover it from the latest full backup. Both the data and the logs can be restored using the FSBasedBackupSets.
Ensure that the following guidelines are met before you start the restore:
-
You need to stop the PostgreSQL server before performing the File System restore to recover the entire PostgreSQL server.
-
Make sure to delete or rename the data directory, user tablespace directory, archive log directory and transaction log directory that is outside the data directory.
-
Restore the File System backups of same version of PostgreSQL and not from higher to lower or lower to higher.
Use the following steps to restore the PostgreSQL server:
-
From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.
-
Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.
-
Click View Content.
-
From the Browse window, select FSBasedBackupSet and click Recover All Selected.
-
From the PostgreSQL Database Restore Options dialog box, click OK.
If you are using PostgreSQL 12, follow the steps mentioned in Consideration for Restoring FSBased Backup Set on PostgreSQL 12.