Restoring PostgreSQL Databases from a DumpBased Backup

You can restore the individual databases (dumps) that are specifically created using dump based backup sets.

To restore entire database to an auxiliary database, see Restore - Restoring Individual Database Tables.

Before You Begin

• Run the PostgreSQL DISCONNECT command to close all the connections to the databases before restoring them.

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

• Before restoring the maintenance database, ensure to clean it up by deleting the database objects like tables, views, etc.

• To restore database using parallel jobs, do the following:

  • Use parallel jobs to dump the PostgreSQL database.

  • If you want to perform stage free restores for Linux clients, verify that the nfs-utils package is installed on the client and configure the 3DFS cache path on the MediaAgent that hosts the 3DFS server.

  • Enter an optimal value for the number of parallel jobs based on the hardware setup of the server, client, and network. For more information, go to the -j command line argument in the PostgreSQL documentation website.

• Create the necessary roles and tablespaces in the destination. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles and tablespaces by default. To back up this information using the pg_dumpall utility, keep this option enabled during backup -enable backups for global objects in the database.

Procedure

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

2. Right-click the DumpBasedBackupSet that contains the databases you want to restore and then click All Tasks > Browse and Restore.

3. Click View Content.

4. Select the databases you want to restore, and then click Recover All Selected.

5. Select Restore in place, and then click Next.

   The PostgreSQL Database Restore Options dialog box appears.

6. In the Number of Streams box, enter the number of data streams to use in the restore operation.

7. In the Number of parallel jobs box, enter the number of parallel jobs to restore the database on Linux and Windows servers.

8. To perform staged restore of database, do the following:

   1. Select Staged restore.

   2. In the Staging path box, enter the location to set the staging path to a local directory.

9. To perform stage-free restore of database, do the following:

   1. Select Stage-free restore.

   2. For Windows servers, in the Username and Password boxes, enter the credentials of the user that can access the MA mount folder.

      Note

      If the MediaAgent is a Linux server, verify the requirements for 3DFS.

10. To stage the global objects file, do the following:

    1. Select the Stage global objects file check box.

    2. To set the staging path for global objects file, in the Staging Path box, enter the location.

11. Click Ok.