Change the log level for a PostgreSQL instance

This topic describes how to change the log level to logical for a PostgreSQL instance.

Background information

If you select Incremental Synchronization when you create a task to migrate or synchronize data from a PostgreSQL instance to an Oracle-compatible tenant of OceanBase Database, you must set the log level parameter wal_level of the instance to logical. Otherwise, the precheck item Check the wal_level parameter of the database will fail.

Procedure

1. Log in to the server where the PostgreSQL instance resides.

2. Open the postgresql.conf configuration file.

3. Find the wal_level parameter and change its value to logical.

   If this parameter does not exist in the configuration file, you can add wal_level = logical to the file.

4. Save and close the file.

5. Restart the PostgreSQL instance for the configuration to take effect.