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

Custom database port

Open marcoslarsen opened this issue 4 years ago • 1 comments

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

  • Which image of the operator are you using? registry.opensource.zalan.do/acid/postgres-operator:v1.5.0
  • Where do you run it - cloud or metal? Kubernetes or OpenShift? AWS K8s
  • Are you running Postgres Operator in production? soon
  • Type of issue? question

Is there a way to customize the database port? (5432 by default). Thanks!

marcoslarsen avatar Aug 04 '21 15:08 marcoslarsen

I don't see a way to specify another port used for the service. I guess your question is related to exposing the service through a loadbalancer. You will need an external IP address for each database cluster as the port number can't be changed.

ErikLundJensen avatar Jul 15 '22 06:07 ErikLundJensen

Upping this! Is there any way to customize the service port? Are there any plans to add that functionality if it's not implemented yet?

alvarobrod avatar Feb 22 '23 09:02 alvarobrod

It's not supported on pod/pg level. But likely not needed. For LBs check the service annotations.

Jan-M avatar Feb 24 '23 23:02 Jan-M

I'm not sure I understand, could you please provide more info on how to handle the LB port through the use of service annotations? I searched for this on the official documentation and didn't find anything related. We are currently using the chart and the LB port is the default 5432, which we would like to change for security. How do you handle this in your environments? Thank you!

alvarobrod avatar Mar 16 '23 13:03 alvarobrod