Restoring PostgreSQL Data from a Backup Copy

You can perform a restore from the backup copy by setting the appropriate copy precedence number.

Before you start the restore, make sure that the PostgreSQL server is offline. Delete or rename the data directory, user tablespace directory, archive log directory and transaction log directory that is outside the data directory.

Procedure

1. From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.

2. Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.

3. Click View Content.

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

5. From the PostgreSQL Database Restore Options dialog box, click Advanced.

6. Click the Copy Precedence tab and select the Restore from Copy Precedence check box.

7. In the Copy Precedence box, type the copy precedence number for the backup copy.

8. Click OK.

9. Click OK in the PostgreSQL Database Restore Options dialog box.