How update conf file postgresql

[monmartins]

How i edit and update conf /stolon-data/postgres/postgresql.conf

[dineshba]

We should not manually edit the postgresql.conf because it is generated(and updated) by stolon. We can use pgparameters in cluster_specification to configure our postgres(keeper). Refer here

[dineshba]

@lwolf Shall we close this issue?

[monmartins]

Already use pgparameters but dont work.

[monmartins]

pgParameters: { shared_preload_libraries : "timescaledb"}

[lwolf]

@monmartins do you mind sharing the details? @dineshba correctly pointed you to the way how it supposed to be done.

[monmartins]

After i add line pgParameters: { shared_preload_libraries : "timescaledb"} in values.yaml and install with helm install . appears on my screen that I still need to add the line, I enter through the kubectl exec -it pod bash and in the file /stolon/postgres/postgresql.conf it continues without being configured.

[monmartins]

Resolve edit statefulset.yaml

      env:
        - name: POD_NAME
          valueFrom:
            fieldRef:
              fieldPath: metadata.name
        - name: STOLONCTL_PATCH
          value: "{ 'pgParameters' : {'shared_preload_libraries' : 'timescaledb' } }"