Checking Whether the Source Table Replication Attribute Is Correct
GaussDB(for openGauss)->GaussDB(for openGauss), GaussDB(for openGauss)->Kafka, PostgreSQL->PostgreSQL and PostgreSQL- >Kafka Synchronization
Check Item |
Whether the source table replication attribute is correct |
---|---|
Description |
The replica identity attribute of the source database table must be full. |
Item to Be Confirmed and Handling Suggestion |
Item to be confirmed: The selected source database table contains the primary key column, but the replication attribute is not FULL. Handling suggestion: Change the replication attribute of the preceding tables to FULL. Run the following statement in the source database: alter table table_name replica identity full; |
Failure Cause and Handling Suggestion |
Failure cause: The source database contains tables whose replication attribute is not Full. As a result, incremental synchronization may fail. Handling suggestion: Change the replication attribute of the table to FULL. Run the following statement in the source database: alter table table_name replica identity full; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.