Updated on 2023-01-05 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, and 13.

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, and 13. If the source database is RDS for PostgreSQL Enhanced Edition, the destination database supports only RDS for PostgreSQL Enhanced Edition.