This topic describes how to migrate the data of an ApsaraDB RDS for PostgreSQL instance from the ApsaraDB RDS for PostgreSQL console to the ApsaraDB RDS console.
Prerequisites
- The source RDS instance runs PostgreSQL 11.
- The source RDS instance runs the latest minor engine version.
Note You can log on to the ApsaraDB RDS for PostgreSQL console and go to the Basic Information page for an RDS instance to view its minor engine version. If the RDS instance does not run the latest minor engine version, you can click Upgrade Minor Version to upgrade its minor engine version.
- The
wal_level
parameter is set tological
for the source RDS instance. - The source RDS instance is managed in the ApsaraDB RDS for PostgreSQL console.
Note You can determine in which console an RDS instance is managed based on the domain name of the console. If the domain name is postgresql.console.aliyun.com, the RDS instance is managed in the ApsaraDB RDS for PostgreSQL console. If the domain name is rdsnext.console.aliyun.com, the RDS instance is managed in the ApsaraDB RDS console.
Background information
Impact
The migration causes a transient connection error. We recommend that you perform the migration during off-peak hours.
Precautions
Each migration task is used to migrate the data of only a single database. If you want to migrate the data of more than one database, create a migration task for each of the databases.
Migration process
Configure the source RDS instance
Configure the destination RDS instance
- Log on to the ApsaraDB RDS console and create an RDS instance that runs PostgreSQL 11. This RDS instance is the destination RDS instance. For more information, see Create an ApsaraDB RDS for PostgreSQL instance.
- Create a privileged account on the destination RDS instance. For more information, see Create an account on an ApsaraDB RDS for PostgreSQL instance.
- Create databases on the destination RDS instance. We recommend that each database on the source RDS instance has a counterpart with an identical name on the destination RDS instance. For more information, see Create a database on an ApsaraDB RDS for PostgreSQL instance.
Use DTS to migrate data
For more information about the precautions, see Migrate incremental data from a user-created PostgreSQL database (version 10.1 to 12) to an ApsaraDB RDS for PostgreSQL instance.
Switch over your workloads to the destination RDS instance
The data migration is complete. Observe the performance of the source RDS instance for a period of time. If your workloads run properly on the destination RDS instance, we recommend that you release or submit a ticket to unsubscribe from the source RDS instance..