PolarDB PostgreSQL Instruction

The DDL synchronization function of Scheduled Task does not apply to PolarDB PostgreSQL databases.

Data Source

You can read partition tables from the PolarDB PostgreSQL database in scheduled tasks, as shown in the following figure.

For details, see Partition Table Creation and Data Reading/Writing.

Data Destination and Mapping

You can select partition tables as data destinations in scheduled tasks, as shown in the following figure.

You can set partition keys when Target Table is set to Auto Created Tables in scheduled tasks, as shown in the following figure.

For details, see Partition Table Creation and Data Reading/Writing.

Details about the configuration method are as follows:

1. PolarDB PostgreSQL 14 supports three partitioning methods: RANGE, HASH, and LIST. PolarDB Oracle 2.0 supports two partitioning methods: RANGE and LIST.

2. RANGE and LIST allow you to select multiple fields as partition fields.

3. RANGE allows you to set multiple partition keys and set the default partition.

4. RANGE and LIST allow you to leave Partition Name empty, in which case a default name will be automatically generated based on the partition position.

5. Explicit partition definitions are required when you create a partitioned table in PolarDB Oracle 2.0. If the source table is a foreign table and unique indexes are created on the target table, you cannot attach the source table as a partition of the target table.

6. PolarDB PostgreSQL 14 allows you to use any column as a primary key or foreign key in a partition table.

7. For interval range partitioning, you cannot specify NULL, Not-a-Number, or Infinity values in a partition key column.

For details, see Overview of Data Pipeline.

1. You can set partition keys when Target Table is set to Auto Created Table in pipeline tasks, as shown in the following figure.

2. Synchronize Source Table Structure Change is supported when the PolarDB PostgreSQL database serves as the target end.

3. Synchronization Without Primary Key is not supported when the PolarDB PostgreSQL database serves as the target end.

For details, see Overview of Data Service.

Data Service allows you to select a partition table as the data source, as shown in the following figure.

This database supports the Database Table Management function but does not support the Lineage Analysis function.