Scenarios - ApsaraDB RDS - Alibaba Cloud Documentation Center

ApsaraDB RDS for PostgreSQL provides the cloud migration feature. This feature uses physical streaming replication to accelerate and simplify cloud migration in various business scenarios. You can use this feature to migrate the data of a self-managed PostgreSQL instance that is deployed on an Alibaba Cloud Elastic Compute Service (ECS) instance or in a data center to an ApsaraDB RDS for PostgreSQL instance. You can also use this feature to migrate the data of an RDS instance across regions or accounts by using backup files. This topic describes the scenarios in which you can use the cloud migration feature.

The following table describes the scenarios.

Scenario	Source instance	Destination instance	Migration link	References
Data migration over an internal network Migrate the data of a self-managed PostgreSQL instance to an RDS instance. Read capability expansion in the cloud Use an RDS instance to offload read requests from a self-managed PostgreSQL instance. Disaster recovery in the cloud Use an RDS instance to run as a hot standby for a self-managed PostgreSQL instance. If the self-managed PostgreSQL instance fails, you can manually switch your workloads from the self-managed PostgreSQL instance to the RDS instance.	Self-managed PostgreSQL instance that is deployed on an Alibaba Cloud ECS instance Self-managed PostgreSQL instance that is deployed in a data center	RDS instance	VPC If the self-managed PostgreSQL instance is deployed on an Alibaba Cloud ECS instance, the ECS instance and the RDS instance must reside in the same virtual private cloud (VPC). If the ECS instance and the RDS instance reside in different VPCs, you must use Cloud Enterprise Network (CEN) to connect the VPCs. For more information, see What is CEN? If the self-managed PostgreSQL instance is deployed in a data center, you must use CEN, VPN Gateway, Express Connect, or Smart Access Gateway (SAG) to connect the data center and the RDS instance over an internal network. For more information,see What is CEN?, What is VPN Gateway?, What is Express Connect?, or What is SAG?	Use the cloud migration feature for an ApsaraDB RDS for PostgreSQL instance
Cross-region migration Migrate the data of an RDS instance to another RDS instance that resides in a different region. Geo-disaster recovery Add RDS instances that reside in different regions to a group to improve disaster recovery capabilities.	RDS instance	RDS instance that is created within the same Alibaba Cloud account but resides in a different region	VPC Use CEN to connect the RDS instances over an internal network.	Migrate data between ApsaraDB RDS for PostgreSQL instances that reside in different regions
Cross-account migration Migrate the data of an RDS instance to another RDS instance that is created within a different Alibaba Cloud account.	RDS instance	RDS instance that is created within a different Alibaba Cloud account	VPC Use CEN to connect the RDS instances over an internal network.	Migrate data between ApsaraDB RDS for PostgreSQL instances within different accounts
Data migration from a PostgreSQL instance that has a public IP address Migrate the data of a self-managed PostgreSQL instance that has a public IP address or a PostgreSQL instance of a third-party cloud service provider to an RDS instance. Note PostgreSQL instances of third-party cloud service providers include self-managed PostgreSQL instances in the cloud or managed PostgreSQL instances, such as Amazon RDS for PostgreSQL, Azure Database for PostgreSQL, and Google Cloud SQL instances.	PostgreSQL instance that has a public IP address or is provided by a third-party cloud service provider	RDS instance	Internet	Migrate the data of a PostgreSQL instance that has a public IP address to an ApsaraDB RDS for PostgreSQL instance