Checking Whether the WAL_LEVEL Value in the Source Database Is Correct

During synchronization from PostgreSQL or GaussDB, 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.
- You can set GaussDB parameters on the database management page and restart the database to apply the settings.
Change the source or destination database version by referring to Supported Databases.