Restoring One or More Databases for Amazon RDS for PostgreSQL

You can browse and restore backed up data of the following:

• Amazon RDS for PostgreSQL databases

• Amazon RDS for PostgreSQL database tables

Prerequisites

• Before initiating the out-of-place restores, create the destination instance and start the destination server.

• To back up roles in the database, enable backups for global objects in the database. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles by default. If you did not have the global objects backed up already, to restore the data with the database user defined in the destination instance properties as the owner, create the additional settings bPGRestoreNoACL and bPGRestoreNoOwner before initiating the restore job.

• To restore from a parallel DumpBased backup, 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.

  • For stage free restores, verify that the following ports are open:

    • For the MediaAgent on a Windows computer, open 111, 445, 2049, and 2050.

    • For the MediaAgent on a Linux computer, open 111 and 2049.

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

• Use additional setting bRestoreRolesFromGlobalFile to override the restore setting and create roles as specified in the global objects dump file.

• Roles are restored by default if global objects are backed up. Starting from Commvault version 11.42.23, global objects are restored by default. If role creation on the destination is not desired, set the additional setting bRestoreRolesFromGlobalFile to False.

• You must only create roles that do not exist.

Procedure

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

   The database Overview tab appears.

2. In the Instances tab, from the Actions row of the instance you want to restore, select Restore.

   Alternatively, click the instance you want to restore, and then click Restore from the Recovery points tile.

   The Backup content page appears.

   Note

   Ensure that you have performed a successful backup on the selected date.

3. From the Database view drop-down list, you can select the following two views:

   • Database view

   • Table view

   Note

   From the View selections tab, you can view your restore selections.

4. Click Restore.

   The Restore options dialog box appears.

5. You can perform the following two types of restores:

   • Perform In-place restore or Out-of-place restore of PostgreSQL Database.

   • Perform In-place restore or Out-of-place restore of PostgreSQL tables.

6. Click Submit.