Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Objects/ Whether the Source Database Contains Unlogged Tables

Updated on 2024-11-30 GMT+08:00

View PDF

Whether the Source Database Contains Unlogged Tables

PostgreSQL as the Source

**Table 1** Whether the source database contains unlogged tables
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."

Parent topic: Database Objects

Previous topic: Checking Whether Objects with the Same Names Exist in the Source Database

Next topic: Checking Whether the Names of Views to Be Migrated Are the Same

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.