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.
Scenarios
The following table describes the scenarios that are applicable to the cloud migration feature.
This feature supports only data migration between RDS for PostgreSQL instances that run the same engine version. To migrate data between instances that run different engine versions, test your business on the destination instance first and then use Data Transmission Service (DTS) to perform the migration. For more information, see Data migration.
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 to make sure that your business can handle read and write requests. | 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 self-managed PostgreSQL instance that is deployed on an ECS instance in the classic network Note We recommend that you use the cloud migration feature to migrate the database after you change the network of the ECS instance from the classic network to a VPC. This way, you do not need to configure NAT gateways for the destination RDS for PostgreSQL instance. For more information, see Use the cloud migration feature for an ApsaraDB RDS for PostgreSQL instance. | Self-managed PostgreSQL instance deployed on an ECS instance in the classic network | RDS for PostgreSQL instance | Internet | |
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. | Self-managed PostgreSQL instance that has a public IP address or PostgreSQL instance provided by a third-party cloud service provider |