Before You Begin
（1） The target self-built PostgreSQL version is 9.5.x, 9.6.x, 10.x, 11.x, 12.x, 13.x and 14.x.
（2） The time zone of the source database must be the same as that of the target database.
（3） Since the CMS will not write the terminator ('\0') to the target self-built PostgreSQL, if the data on the source database contains the terminator, the CMS will not write the terminator to the target database, resulting in data inconsistency.
Permission Requirements of Target 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 Target Server
Data source type: Set this parameter to PostgreSQL. The source database can be migrated to the PostgreSQL databases within the version range.
Server IP: Specifies the IP address of the target database.
Port number: Specifies the port of the target database.
User name: Specifies a user name used to connect to the target database.
Password: Specifies the password of the user used to connect to the target database.
Database: Specifies the name of the database used by the target server to receive data from the source server.
Schema: Specifies the schema name used by the target server to receive data from the source server.