This topic describes how to restore the data of an ApsaraDB RDS for PostgreSQL instance from a cross-region backup file to a new RDS instance. The new RDS instance must reside in the region in which the cross-region backup file is stored.

Prerequisites

The cross-region backup feature is enabled. For more information, see Use the cross-region backup feature for an ApsaraDB RDS for PostgreSQL instance.
Note

Procedure

  1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Backups. In the top navigation bar, select the region in which the RDS instance resides.
  2. On the page that appears, choose Cross-region Backup > Backup Instances, find your RDS instance, and then click the ID of the instance. On the page that appears, find the backup file that you want to use and click Restore in the Actions column.
  3. On the Restore Database page, set Billing Method to Subscription or Pay-As-You-Go and configure the following parameters.
    Parameter Description
    Restore Mode
    • By Backup Set: allows you to restore the data of your RDS instance from a data backup file.
    • By Time: allows you to restore the data of your RDS instance to a specific point in time. The point in time must be within the specified log backup retention period.
    By Backup Set The data backup file from which you want to restore the data of your RDS instance. This parameter appears only when you set the Restore Mode parameter to By Backup Set.
    By Time The point in time to which you want to restore the data of your RDS instance. This parameter appears only when you set the Restore Mode parameter to By Time.
    Note Both local and cross-region log backup files can be used to restore the data of your RDS instance to a specific point in time.
    Region The region to which the new RDS instance belongs.
    Note You can select only the region to which the cross-region backup files of your RDS instance are stored.
    Zone of Primary Node The zone where the new RDS instance resides. Each zone is an independent physical location within a region. Zones in the same region do not have substantial differences. The new RDS instance can reside in the same zone or in a different zone than the Elastic Compute Service (ECS) instance that you want to connect.
    Instance Type The instance type of the new RDS instance. Each instance type supports a different number of cores, memory capacity, maximum number of connections, and maximum IOPS. For more information, see Primary ApsaraDB RDS instance types.
    Capacity The storage capacity that is provided to store data files, system files, binary log files, and transaction files in the RDS instance.
    Note The settings of some parameters cannot be modified. These parameters include Database Engine, Version, and Edition. The same settings of these parameters must be specified for both your RDS instance and the new RDS instance.
  4. Specify the Duration and Quantity parameters. Then, click Buy Now. You must specify the Duration parameter when the new RDS instance is billed on a subscription basis.
  5. On the Order Confirmation page, read and select Terms of Service, Service Level Agreement, and Terms of Use. Then, click Pay Now and complete the payment.

References

After you create an RDS instance, you must configure IP address whitelists or security groups and create accounts. For more information, see Configure an IP address whitelist for an ApsaraDB RDS for PostgreSQL instance and Create an account on an ApsaraDB RDS for PostgreSQL instance. If you want to connect to the RDS instance over the Internet, you must also apply for a public endpoint. For more information, see Apply for or release a public endpoint on an ApsaraDB RDS for PostgreSQL instance. After you complete these operations, you can connect to the RDS instance. For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.