postgres-operator Expose services over NodePort

For migration purposes we must expose postgres outside of k8s cluster, our main exposure method is a NodePort.

It would be nice if cluster CRD will allow to alter service type to a NodePort and optionally specify a value for nodeport number

May 19 '20 12:05 k0da

I would also like this option!

May 28 '20 16:05 nutellinoit

Sounds like a reasonable small PR to do. There is some code already around service creation and config so that would be the place to start. (compare lb vs non lb service)

Jun 04 '20 17:06 Jan-M

There is a WIP PR https://github.com/zalando/postgres-operator/pull/994 from me

Jun 04 '20 17:06 k0da

Thanks. I am waiting for this option too

Jun 29 '20 08:06 arpitarathi

Can one simply update the ClusterIP service to be of NodePort type while we wait for @k0da's PR to approve?

Feb 03 '21 16:02 worldofgeese

I'll also take the risk of drawing @Jan-M's attention back to this one.

Feb 04 '21 15:02 worldofgeese

Still no update on this?

Mar 23 '21 16:03 Vivida1

We're using a NodePort Ingress as a workaround for this, would really love to get native NodePort support.

Oct 13 '21 11:10 kien-truong

NodePort could be very helpful feature for migration purposes.

Sep 05 '23 20:09 darkfessing

opened another PR for this: https://github.com/zalando/postgres-operator/pull/2986

Nov 15 '25 14:11 lucasl0st