Before You Begin
(1) The target self-built PostgreSQL database version is 9.5.x, 9.6.x, 10.x, 11.x, 12.x, 13.x, or 14.x, and the version is later than or the same as that of the source database.
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 synchronized 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.