All Products
Search
Document Center

ApsaraDB for OceanBase:Change the log level for an ApsaraDB RDS for PostgreSQL instance

Last Updated:Jan 03, 2024

This topic describes how to change the log level to logical for an ApsaraDB RDS for PostgreSQL instance.

Background information

If you select Incremental Synchronization when you migrate data from an ApsaraDB RDS for PostgreSQL instance to an Oracle tenant of OceanBase Database, you must change the log level of the instance to logical, that is, set wal_level to logical. Otherwise, the project precheck item Check the wal_level parameter of the database will fail.

Procedure

  1. Log on to the ApsaraDB RDS console.

  2. In the upper-left corner of the Instances page, select the region where the target instance is located. Then, click the ID of the instance.

  3. On the instance details page, click Parameters in the left-side navigation pane.

  4. On the Modifiable Parameters tab, search for the wal_level parameter.

    image.png

  5. Click the edit icon next to the running value of the parameter, change the value to logical, and click OK.

    image.png

  6. Click Apply Changes on the Modifiable Parameters tab for the modification to take effect.

    image.png

  7. Click Restart Instance in the upper-right corner of the Parameters page.

  8. In the Restart Instance dialog box, click OK.