Checking Whether the Source Table Replication Attribute Is Correct
GaussDB->GaussDB, GaussDB->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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot