Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Table Replication Attribute Is Correct
Updated on 2024-05-09 GMT+08:00
View PDF
Share

Checking Whether the Source Table Replication Attribute Is Correct

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

Table 1 Checking whether the source table replication attribute is correct

Check Item

Whether the source table replication attribute is correct

Description

Check the replication attribute of the table in the source database.

Failure Cause and Handling Suggestion

Item to be confirmed: The source database table contains the primary key column, but the replication attribute is not FULL. When the source table data is updated, if the replication attribute of the table is not FULL, the source database logs may not record the old values of all columns, causing data loss.

Handling suggestion: Run the following statements to change the replication attribute of the preceding tables to FULL:

alter table sch1.t varchar replica identity full;

alter table sch1.t char replica identity full;
Parent topic: Database Parameters