patroni.dynamicConfiguration with pg_hba settings

Hi Team,

How can I overwrite pg_hba configuration for patroni? I don’t see any parameter available in this document: Custom Resource options - Percona Operator for PostgreSQL

I have installed this operator in kubernatese cluster however my backend pod which have connection string is failing to connect and giving error "28000: no pg_hba.conf entry for host “x.x.x.x”, user “xyz”, database “xyz”, no encryption.

Is available and we can just go ahead and add it?

K8 Postgresql Operator use configmap and you can view and edit pg config + pg_hba.conf using below commands,


$ kubectl get cm  -n pgo
NAME                        DATA   AGE
kube-root-ca.crt            1      23h
pgo-deployer-cm             1      23h
pgo-config                  40     23h
cluster1-sat-night-backup   1      23h
cluster1-config             0      22h
cluster1-pgbouncer-cm       2      22h
testcm                      1      19h
cluster1-pgha-config        5      23h
cluster1-leader             0      22h

view pgha-config

$ kubectl describe cm cluster1-pgha-config -n pgo

Edit/update pgha-config

$ kubectl edit cm cluster1-pgha-config