Restore RDS PostgreSQL data across regions - ApsaraDB RDS

Prerequisites

Before you begin, ensure that you have:

Cross-region backup enabled for your RDS instance. For instructions, see Use the cross-region backup feature.

You can only restore to a new instance. Restoring to an existing instance is not supported.

Log in to the ApsaraDB RDS console. In the left-side navigation pane, click Backups.
In the top navigation bar, select the region in which your RDS instance resides.
On the Cross-region Backup tab, click the Backup Instances tab. Find your instance and click its ID.
Locate the backup set to restore from, then click Restore in the Actions column.
In the confirmation dialog, click OK.

On the Restore Database page, configure the following parameters.

Database Engine, Version, and Edition are fixed and must match the source instance. They cannot be changed.

Parameter	Description
Billing method	Subscription: Pay upfront for a fixed term. More cost-effective for long-term use. Pay-As-You-Go: Billed per hour based on actual usage. Suitable for short-term use or evaluation.
Restore method	By Backup Set: Restore from a specific backup set. By Time: Restore to a point in time within the log backup retention period. Both local and cross-region log backups can be used for point-in-time restore.
By Backup Set	The backup set to restore from. Appears only when Restore method is set to By Backup Set.
By Time	The point in time to restore to. Appears only when Restore method is set to By Time.
Region	The region for the new instance.
Zone	The zone for the primary and secondary nodes. Choose Single-zone Deployment to place both nodes in the same zone, or Multi-zone Development to place them in different zones for zone-level disaster recovery. After the instance is created, view zone details on the Service Availability page. If you select RDS Basic Edition, only single-zone deployment is available.
Instance type	Determines the number of CPU cores, memory capacity, maximum connections, and maximum IOPS. See Primary ApsaraDB RDS instance types.
Capacity	Maximum storage for data files, system files, binary log files, and transaction files.
Duration	The subscription period. Applies only when Billing method is set to Subscription.

Click Next: Instance Configuration and configure the following:

Parameter	Description
Network type	Select VPC (virtual private cloud). Configure the VPC and vSwitch of Primary Node parameters. If you selected Multi-zone Development in the previous step, also configure the vSwitch of Secondary Node parameter.
Resource group	The resource group for the new instance.

Click Next: Confirm Order. Review the settings in the Parameters section, then configure Purchase Plan and Duration (Duration applies only to subscription instances). Read and accept the Terms of Service, click Pay Now, and complete the payment.

For subscription instances, select Auto-Renew Enabled to avoid service interruptions if a payment becomes overdue.
(Optional) Log in to the new instance and verify the restored data. See Connect to an ApsaraDB RDS for PostgreSQL instance.

After the instance is created, complete the following setup before connecting:

Configure an IP address whitelist or a security group.
Create an account on the new instance.
(Optional) Apply for a public endpoint if you need to connect over the Internet.
Connect to the instance.

Related topics: