If any undesired transaction occurs in the database, you can revert the volume in which the data directory is located to the snapshot available from a successful snap or block level backup. Revert restores are supported for FSBasedBackupSets only. When you perform a hardware revert restore for a database, the next scheduled backup for that database will automatically convert to a full backup. Revert operation can be performed from snapshot backup using hardware engine type only.
Note
Revert operations cannot be performed in a Windows cluster environment.
Before You Begin
-
Stop the PostgreSQL server.
-
Ensure that no other applications are using the volume.
-
The entire volume will be reverted back using the snapshot, ensure there is no data loss if any other application files are present in the same volume.
-
Review the supported configurations for revert operation. For more information, see Revert for Storage Arrays.
Procedure
-
From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
-
Right-click the FSBasedBackupSet, point to All Tasks, and then click Browse and Restore.
-
Click View Content.
-
In the right pane of the window, select one or more databases that you wish to restore and click Recover All Selected.
-
Click Advanced.
-
Select the Use hardware revert capability if available check box.
-
Click Yes in the confirmation box to shutdown the PostgreSQL server. The server will be shutdown (if it is running) before the revert operation is performed.
-
Click OK to confirm the revert operation.