Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Objects/ Checking Whether the Source Database Contains Unlogged Tables
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database Contains Unlogged Tables

PostgreSQL as the Source

Table 1 Checking 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."