> Documentation > Backup and Restore Agents > Databases > PostgreSQL > PostgreSQL Block-Level Backup > Restore PostgreSQL Database Tables and Instances from a Block-Level Backup

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 delete or rename the data directory, user tablespace directory, archive log directory and transaction log directory that is outside the data directory.

Restrictions

  • 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.

Procedure

  1. From the CommCell Browser, expand Client Computers > Client > PostgreSQL > Instance.

  2. Right-click FSBasedBackupSet, point to All Tasks, and then click Browse and Restore.

  3. On the Browse and Restore Options dialog box, click View Content.

  4. From the Browse window, select FSBasedBackupSet, and then click Recover All Selected.

    The PostgreSQL Database Restore Options dialog box is displayed.

  5. 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.

    If you are using PostgreSQL 12, follow the steps mentioned in Consideration for Restoring FSBased Backup Set on PostgreSQL 12.

  6. Click OK.

Notes

  • 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.

Loading...