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.
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.