Restoring a Database Group for Amazon RDS for PostgreSQL

You can browse and restore one or more databases.

Before You Begin

• 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 that hosts the 3DFS server.

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

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

  • For the Backup Gateway 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.

Procedure

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

   The database Overview page appears.

2. Go to the Instances tab.

3. Click the instance.

   The instance Overview page appears.

4. Go to the Database groups tab.

5. Under Database groups, for the database group that you want to back up, click the action button , and then click Restore.

   The Backup content page appears.

6. Select the databases that you want to restore, and then click Restore.

   The Restore options dialog box appears.

7. Perform one of the following restore operation as per the requirement:

   • In-place restore

   • Out-of-place restore

8. Click Submit.