Checking Whether the Source Database Contains Unlogged Tables
PostgreSQL as the Source
Check Item |
Whether the source database contains unlogged tables |
---|---|
Description |
Check whether the source database contains unlogged tables. If yes, the synchronization fails. |
Item to Be Confirmed and Handling Suggestion |
Item to be confirmed: The source database contains unlogged tables and modifications to these tables are not recorded in logs. As a result, incremental data of unlogged tables cannot be synchronized. Handling suggestions: Check whether incremental data of the unlogged tables needs to be synchronized. If yes, run the following command to change the unlogged tables to logged: ALTER TABLE TABLE_NAME SET LOGGED." |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.