Restoring Amazon RDS for PostgreSQL to a Current Location (In Place)

You can restore a Restoring Amazon RDS for PostgreSQL database to its current location (in place).

To recover only the data, perform the restore by using a full backup.

Procedure

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

   The database Overview tab appears.

2. On 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.

3. Select the DumpBasedBackupSet, and then click Restore.

   The Restore options dialog box opens.

4. Select In place.

5. In the Number of streams box, enter the number of data streams that you want to use for backups.

6. Optional: From the Select MediaAgent list, select a Backup Gateway.

7. Under Pre or Post options, do the following:

   • In the Pre recovery command box, enter the name or path of the process to run before the restore.

   • In the Post recovery command box, enter the name or path of the process to run after the restore.

   • If you want to initiate the restore as user, move the Run as user toggle key to right.

     • In the User name box, enter a user name you want to run the restore with.

8. To send a notification email when the restore job completes, select the When the job completes, notify me via email.

9. Click Submit.