Restoring a PostgreSQL Server to a Disk (Application-Free Restore)

You can browse and restore backed up data to a disk for an entire database or for individual databases.

For an IntelliSnap subclient or a block-level enabled subclient, you can restore only transaction logs to a disk. For a regular subclient, you can restore both data and logs to a disk.

Before You Begin

• Perform a backup.

• Verify that the PostgreSQL software version on the destination is the same version or higher than the software version.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The Instances page appears.

2. Click an instance.

   The instance page appears.

3. In the Backup sets section, click FSBasedBackupSet.

   The FSBasedBackupSet page appears.

4. Click Backup history.

   The Job history page appears.

5. Right-click a job ID, and then click Restore.

   The Select databases to restore from page appears.

6. Click Restore.

   The Restore options dialog box appears.

7. On the Restore to disk tab, complete the following steps:

   1. From the Destination Client list, select the destination host for the restore.

   2. In the Destination folder box, type or browse the folder where you want to restore the data.

   3. To restore only the log files, select the Restore transaction logs only check box.

8. To use a different account than the one configured for the PostgreSQL instance, move the Impersonate user toggle key to the right, and then enter the user name and password that have the necessary permissions to restore the application data.

9. To use a different MediaAgent than the one selected by default, from the list select a MediaAgent.

10. Click Submit.