How to change wal_level to logical in postgresql database when configured via Helm charts

Question

I deployed timescale-postgresql using helm:

• Chart Name: timescalepostgres timescale/timescaledb-single --version 0.33.1

In the values.yaml file I kept the wal_level = logical, however after the deployment I see wal_level still showing the default value of replica.

How to change it?

During the helm chart deployment I explicitly mentioned the wal_level:logical, however it is not changing the default value of replica.

Answer 1

If the values.yaml file's wal_level: logical setting isn't applied during deployment, make sure the YAML syntax is right, verify the compatibility of the Helm chart version, and use --set when installing or upgrading. If problems still arise, you might want to try setting up PostgreSQL directly with SQL (ALTER SYSTEM SET wal_level = 'logical';).

Hope it works :)