Modify the log level of a self-managed PostgreSQL instance

This topic describes how to change the log level of a self-managed PostgreSQL database instance to logical.

Background information

When you migrate data from a self-managed PostgreSQL database instance to OceanBase Database, if you select Incremental Synchronization, you must set the log level of the PostgreSQL instance to logical (that is, set the value of the wal_level parameter to logical). If you do not set it, the task pre-check item Database wal_level Check will fail.

Procedure

1. Log in to the server where the PostgreSQL instance is located.

2. Open the PostgreSQL configuration file postgresql.conf.

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

   If the parameter does not exist in the configuration file, you can add the following line: wal_level = logical.

4. Save and close the postgresql.conf file.

5. Restart the PostgreSQL instance to apply the changes.