Before You Begin
(1) The source CT-RDS PostgreSQL database version is 9.4, 10, 11, 12, or 13.
(2) In a CT-RDS 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.
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 |
For the configuration on the source database, see Configure Migration Tasks with Self-built PostgreSQL Database as Source.