Connect locally running pgAdmin with master Pod

[TAM360]

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

• Which image of the operator are you using? ghcr.io/zalando/spilo-15:2.1-p9
• Where do you run it - cloud or metal? Kubernetes or OpenShift? Bare Metal K8s v1.24
• Are you running Postgres Operator in production? no
• Type of issue? question

Hi everyone, I am currently experimenting with Postgres Operator as a replacement of Stolon. I want to access the Postgres database outside of K8s cluster. The problem is that every time I create a DB through CRD, 2 services get created of type ClusterIP:

• 1 with replica Pod's selectors
• Other one without any master Pod's selector

I've 2 questions:

1. How can I connect a DB client (e.g pgAdmin or Databricks) running on my local machine with the master DB pod? I can port-forward the master Pod as mentioned in the documentation but I want to use service instead.
2. How will applications connect with master Pod when they're deployed in k8s cluster?

[dmvolod]

Hi @TAM360 ,
enableMasterLoadBalancer should be set to true for that. Please see following docs.

https://postgres-operator.readthedocs.io/en/latest/administrator/#load-balancers-and-allowed-ip-ranges

Please note, that NodePort option still in progress #994

[TAM360]

The documentation doesn't answer my 2nd question. Also, I have bare metal k8s cluster. There's no option for using LoadBalancing type service (it works only in cloud based K8s).

[dmvolod]

The documentation doesn't answer my 2nd question. Also, I have bare metal k8s cluster. There's no option for using LoadBalancing type service (it works only in cloud based K8s).

Yes and no, of you install MetalLB, this should work on the baremetal k8s
Otherwise, NodePort is not supported yet

[TAM360]

Okay. BTW, what's the reasons of not master service not having selectors?

[dmvolod]

This is headless service by design. Please see conversation in #1467