Help Center> Data Replication Service> Troubleshooting> Solutions to Failed Check Items> Database Parameters> Partition Table Check on the Source Database
Updated on 2024-05-09 GMT+08:00
View PDF

Partition Table Check on the Source Database

Synchronization from PostgreSQL to GaussDB and from PostgreSQL to GaussDB(DWS)

Table 1 Partition table check on the source database

Check Item

Partition table check on the source database

Description

Check whether the source database has partition tables.

Failure Cause and Handling Suggestion

Item to be confirmed: If the source database contains partition tables and source partitions are modified or are deleted during data synchronization, partition data may fail to be synchronized or the synchronization may fail.

Handling suggestion: The source partition must be a newly-created partition, and the partition name must be unique. This partition can be deleted from the source database only after all data is synchronized to the destination database.
Parent topic: Database Parameters