search

zalando / postgres-operator

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
https://postgres-operator.readthedocs.io/
MIT License
4.37k stars 981 forks source link

Pooler: WARNING server login failed: FATAL permission denied for database #2654

Open bck01215 opened 5 months ago

bck01215 commented 5 months ago

Please, answer some short questions which should help us to understand your problem / question better?

pgbouncer logs

│ 2024-06-05 12:50:01.493 UTC [1] WARNING C-0x7f43b89a91a0: (nodb)/(nouser)@10.4.2.155:42164 pooler error: SSL required                                                                                          │
│ 2024-06-05 12:50:01.499 UTC [1] LOG C-0x7f43b89a91a0: (nodb)/(nouser)@10.4.2.155:42170 registered new auto-database: db=fm                                                                                     │
│ 2024-06-05 12:50:01.530 UTC [1] WARNING server login failed: FATAL permission denied for database "fm"                                                                                                         │
│ 2024-06-05 12:50:06.813 UTC [1] WARNING server login failed: FATAL permission denied for database "fm"                                                                                                         │

pg_hba.conf

    ...
      - local pooler all  trust
      - host all all all md5
      - hostssl  all +pamrole all pam

I am unsure what needs to be added to the pg_hba.conf to allow the pooler