Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the WAL_LEVEL Value in the Source Database Is Correct
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Checking Whether the WAL_LEVEL Value in the Source Database Is Correct

During PostgreSQL synchronization, the wal_level parameter of the source database must be set to logical. If the value is not logical, the incremental logs of the source database cannot be logically decoded. As a result, incremental synchronization cannot be performed.

Failure Cause

  • The wal_level value of the source database is not logical.
  • The source or destination database version is not supported.

Handling Suggestion

  • Change the value of wal_level in the source database to logical. For details, see the following:
    • Run alter system set wal_level = logical in the source database as a super user and restart the database to apply the changes.
    • Alternatively, modify the postgresql.conf configuration file, set wal_level to logical, and restart the database to apply the changes.
  • Change the source or destination database version by referring to Supported Databases.
Parent topic: Database Parameters