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.
The following table describes the scenarios.
Scenario | Source instance | Destination instance | Migration link | References |
Data migration over an internal network | Self-managed PostgreSQL instance that is deployed on an Alibaba Cloud ECS instance | RDS for PostgreSQL instance | VPC
| Use the cloud migration feature for an ApsaraDB RDS for PostgreSQL instance |
Read capability expansion in the cloud Use an RDS instance to offload read requests from a self-managed PostgreSQL instance. | Self-managed PostgreSQL instance that is deployed on an Alibaba Cloud ECS instance or in a data center | |||
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 or in a data center | |||
| RDS for PostgreSQL instance | RDS for PostgreSQL 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 for PostgreSQL instance | RDS for PostgreSQL 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 for PostgreSQL instance | Internet |