Restoring a PostgreSQL Instance to the Same Host
By default, the software restores an instance to the same location from where it was backed up. You can also restore an instance to a different PostgreSQL instance.
Important: Do not use this method if you have files or folders other than PostgreSQL data directory, tablespace directory and archive log directory in the same volume. In such a case, you can perform a table level browse operation and a database level restore operation excluding the maintenance and template database.
Before You Begin
Stop the PostgreSQL server, and rename the WAL and data directories.
- Revert restore operation is supported only for hardware snap engines.
- When you perform a revert restore operation, make sure that the volume is not in use.
- From the CommCell Browser, expand Client Computers > Client > PostgreSQL > Instance.
- Right-click FSBasedBackupSet, point to All Tasks, and then click Browse and Restore.
- On the Browse and Restore Options dialog box, click View Content.
- From the Browse window, select FSBasedBackupSet, and then click Recover All Selected.
The PostgreSQL Database Restore Options dialog box is displayed.
- Optional: To restore this PostgreSQL instance to a different instance on the same client, from the Destination Server list, select the name of the destination instance.
- Click OK.
- You can also perform a full instance restore from the instance level by either selecting Restore PostgreSQL Server or Browse and Restore:
- If you select Restore PostgreSQL Server, from the Data Path tab of the Advanced Restore Options dialog box, select a Linux MediaAgent before running the restore operation.
- If you select Browse and Restore, from the Advanced Options tab of the Browse and Restore Options dialog box, select a Linux MediaAgent before running the restore operation.
- The file permissions for the staging directory must be set to 777.
- Do not use root directory as a staging location.
Last modified: 5/15/2020 11:52:10 AM