Updated on 2022-08-16 GMT+08:00

Checking Whether the WAL_LEVEL Value in the Source Database Is Correct

PostgreSQL Synchronization

Table 1 Checking whether the WAL_LEVEL value in the source database is correct

Check Item

Whether the WAL_LEVEL value in the source database is correct

Description

Check whether wal_level of the source database is 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 and Handling Suggestion

Failure cause: The wal_level value in the source database is incorrect.

Handling suggestion: Change the wal_level value of the source database to logical. For details about how to modify the parameter for self-built databases, see:
  • 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.

Failure cause: The source database version is not supported.

Handling suggestion: Ensure that the source database version is supported by DRS. Supported source database versions include PostgreSQL 9.4, 9.5, 9.6, 10, 11, 12, 13, and RDS for PostgreSQL Enhanced Edition.

Failure cause: The destination database version is not supported.

Handling suggestion: Ensure that the destination database version is supported by DRS. The destination database supports the following major versions: RDS for PostgreSQL 9.5, 9.6, 10, 11, 12, 13, and Enhanced Edition. If the source database is RDS for PostgreSQL Enhanced Edition, the destination database supports only RDS for PostgreSQL Enhanced Edition.