How to set patroni parameters remove_data_directory_on_diverged_timelines and remove_data_directory_on_rewind_failure?

[pdixit26]

It seems zalando is not exposing them https://github.com/zalando/postgres-operator/blob/master/pkg/apis/acid.zalan.do/v1/postgresql_type.go#L173
I would like to override the default values(which is false for both the parameters)

[mg1986jp]

You're right that those parameters aren't directly exposed in the postgresql CRD spec. But you should be able to set them through the patroni section of the postgresql manifest using the configuration field for DCS parameters:

apiVersion: acid.zalan.do/v1
kind: postgresql
spec:
  patroni:
    loop_wait: 10
    retry_timeout: 10
    synchronous_mode: false
    # DCS parameters go under postgresql.parameters or in bootstrap

Actually, remove_data_directory_on_diverged_timelines and remove_data_directory_on_rewind_failure are Patroni DCS configuration parameters, not PostgreSQL parameters. They might need to go under a patroni section that maps to the DCS config.

If the operator doesn't expose them, you could try setting them directly in the Patroni DCS (etcd/Kubernetes endpoints) using patronictl edit-config, though that's a manual override and the operator might overwrite it on reconciliation.

Another option is to use the PATRONI_REMOVE_DATA_DIRECTORY_ON_DIVERGED_TIMELINES=true environment variable on the spilo pods, if the operator lets you pass custom env vars.