Before You Begin
（1） The source self-built PostgreSQL database version is 9.5.x, 9.6.x, 10.x, 11.x, 12.x, 13.x, or 14.x.
（2） In a self-built PostgreSQL database, set wal_level=logical for the WAL log, and max_replication_slots is greater than 10.
（3） The storage space of the target database must be greater than that used by the source database.
（4） During incremental data migration, the CMS creates a replication slot with the suffix _cloud_log_slot in the source database to replicate data.
（5） After the task is complete, the replication slot is automatically deleted. If you change the database password or delete the IP address trustlist during the migration, the replication slot cannot be automatically deleted. In this case, you must manually delete the replication slot on the source database. This prevents RDS PostgreSQL instances from becoming unavailable due to continuous accumulation of disk space usage.
（6） If an active/standby switchover occurs in the PostgreSQL database, log in to the standby database to manually clean up the database.
Limitations
Tables without primary keys only support full data migration, but not incremental data migration or auditing repair.
Table structure, full data, and incremental data of the source database can be migrated.
Permission Requirements of Source Server
Migration Mode | Required Permissions |
Full Data Migration | Schema level: USAGE Table level: SELECT |
Incremental Data Migration | The user is a super user or a replication role. Method to assign a replication role: alter user username with replication Schema level: USAGE Table level: SELECT |
Auditing Repair | Schema level: USAGE Table level: SELECT |
Configuration on Source Server
Data source type: Set this parameter to PostgreSQL. PostgreSQL databases within the version range can be migrated.
Server IP: Specifies the IP address of the source database to be migrated.
Port number: Specifies the port of the source database to be migrated.
User name: Specifies a user name used to connect to the source database to be migrated.
Password: Specifies the password of the user used to connect to the source database to be migrated.
Database: Specifies the name of the source database to be migrated.
Schema: Specifies the schema name used by the source server from which data is migrated.