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
- Failure Cause
- Handling Suggestion