postgres-operator icon indicating copy to clipboard operation
postgres-operator copied to clipboard

Application can not connect to zalando postgres

Open zainal-abidin-assegaf opened this issue 3 years ago • 5 comments

image

image

I can access zalando from cli: image

my config: image

Please help, Thank you

zainal-abidin-assegaf avatar Jun 22 '21 02:06 zainal-abidin-assegaf

Hi @4ss3g4f I think you just need to add the following below to a connection string in your application

SSL Mode=Require;Trust Server Certificate=true

kirillka415 avatar Jun 22 '21 05:06 kirillka415

Why must SSL Mode be required inside a kubernetes cluster? Didn't read this in the docs. Is there a config flag to disable this?

codezork avatar Aug 20 '21 10:08 codezork

ALLOW_NOSSL: true here -> https://github.com/zalando/postgres-operator/blob/master/docs/administrator.md#custom-pod-environment-variables

kamikazechaser avatar Dec 02 '21 15:12 kamikazechaser

apiVersion: v1
kind: ConfigMap
metadata:
  name: postgres-pod-config-custom-env
  namespace: default
data:
  ALLOW_NOSSL: "true"

helm-values (check "pod_environment_configmap"):

configKubernetes:
  cluster_name_label: kubernetes-prod
  pod_environment_configmap: default/postgres-pod-config-custom-env
  custom_pod_annotations:
    linkerd.io/inject: enabled

FredyR4zox avatar Feb 10 '22 12:02 FredyR4zox

@FredyR4zox, my man! Thank you!

This SSL stuff is too chaotic, it has to be hashed out in future versions of the operator

caniko avatar Aug 09 '22 15:08 caniko