Restoring One or More Database for Alibaba Cloud ApsaraDB RDS for PostgreSQL

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

• Alibaba Cloud ApsaraDB RDS for PostgreSQL

• Alibaba Cloud ApsaraDB RDS for PostgreSQL tables

Before You Begin

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

• You must only create roles that do not exist.

Procedure

1. From the Command Center 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 , 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:

   • Database view

   • Table view

   Note

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

5. Click Restore.

   The Restore options dialog box appears.

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

7. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

   1. Click Schedule.

      The Add schedule dialog box appears.

   2. In the Name box, type a name for the schedule.

   3. Configure the Frequency and Repeat parameters.

   4. To specify exceptions to the schedule, click Exceptions.

      The Exceptions dialog box appears.

   5. Configure the exception parameters:

      • You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

      • Click Save when you have finished configuring the exception parameters.

   6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

   7. To save the schedule and return to the restore dialog box, click Schedule.

8. Click Submit.