If any undesired transaction occurs in the database, you can revert the database to a state just before the transaction. The point in time option enables you to restore the database to a specific point-in-time. Point-in-time restores are supported for FSBasedBackupSets only. This option is useful in the following scenarios:
-
If any undesired transaction occurs in the database, you can revert the database to a state just before the transaction.
-
If a database fails, you can restore to the state just before the point of failure.
-
You can restore multiple databases to a consistent time. This will be useful for the absolute synchronization of the databases.
When you perform a point-in-time restore for a database, the next scheduled backup for that database will automatically convert to a full backup.
-
You need to stop the PostgreSQL server before performing the File System restore to recover the entire PostgreSQL server to a point in time.
-
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.
-
Before performing the point-in-time restore of a database, ensure that transaction logs for the database are backed up.
Follow the steps given below to restore a database(s) to a point in time:
-
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, select the Point in Time check box.
-
From the Restore Time list, select the date and time. The restore time selected must be later than the browse time.
-
Click OK.