Postgres-operator: Add non ssl pgbouncer mode

[sergeyshaykhullin]

I can't connect to DB(sslmode=disable) using "-pooler" service

But i can connect to db directly

[FxKu]

All connections are encrypted by default, but check #868.

[sergeyshaykhullin]

@FxKu But why i can connect directly to pg with sslmode=disable, but can't with pooler service. Do you mean, that all pgbouncer connections with ssl by default?

[sergeyshaykhullin]

I tested ALLOW_NOSSL, but it doesn't work with pooler. I still can connect without tls to pg directly and can't using pooler.

Helm setup

configKubernetes:
  pod_environment_configmap: "{{ release.namespace }}/postgresql-pod-environment"

Configmap

apiVersion: v1
kind: ConfigMap
metadata:
  name: postgresql-pod-environment
  namespace: "{{ release.namespace }}"
data:
  ALLOW_NOSSL: "true"

[FxKu]

@sergeyshaykhullin sorry for the delay. Checked our pooler image and SSL is hard coded there. So you could either use your own pooler image or stick to application-side connection pooling.

[mboutet]

@FxKu, could you point me to your pooler Dockerfile (and related scripts like entrypoint and such)? I tried searching on the Zalando's repositories, but I couldn't find anything specific to the pooler. Thank you