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.

Checking Whether the WAL_LEVEL Value in the Source Database Is Correct

PostgreSQL Synchronization