Restoring One or More Amazon RDS for PostgreSQL Database

You can browse and restore backed up data for an entire instance or for individual databases.

Procedure

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

    The database Overview page appears.

  2. Go to the Instances tab.

  3. In the row for the instance, click the action button action_button, and then click Restore. Alternatively, click the instance you want to restore, and then in the Recovery points, click Restore.

    The Backup content page appears.

    Note

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

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

    1. Database view

    2. Table view

  5. Select Database view to restore the databases.

  6. Select Table view to restore the schemas and tables of the database.

    Note

    • If you select a public or user-created schema within the database and then choose a table under that schema, only the schema selection takes precedence.

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

  7. Click Restore.

    The Restore options dialog box appears.

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

Loading...