PolarDB PostgreSQL to Greenplum Data Replication

This page describes how to configure one-way schema and full replication from Alibaba Cloud PolarDB for PostgreSQL to Greenplum.

Before you begin

• Add the PolarDB PostgreSQL source and Greenplum target data sources to NineData. See Create a PolarDB for PostgreSQL data source and Create a Greenplum data source.
• Make sure your account can access the selected source and target databases. Use the task precheck results to identify the required privileges.

Procedure

1. On the Data Replication page, create a one-way replication task and enter a task name.
2. Select the PolarDB PostgreSQL source in Source and the Greenplum target in Target.
3. Under Type, select Schema and Full. This procedure does not configure Incremental.
4. Select the source objects and map them to the target database, schema, and table names. Confirm that the target objects are the intended write destinations.
5. After you finish the configuration, run Save and perform pre-check. If the precheck fails, review the failed items, correct the configuration, and run the precheck again.
6. After saving the task and passing the precheck, open the task details and start the task.

caution

Full replication writes data to the target objects. Before starting the task, review the target data source, database, and object mappings to confirm the intended write scope.

Result

Review the schema and full replication status and completed record count on the task details page.

Next steps

• Data Replication overview