how to connect to postgresql on Kubernetes cluster?

Question

I have deployed my crunchy db postgresq on my Kubernetes cluster.

However, I am not sure how to connect to the database remotely.

What command can I use to connect remotely so I can create a new database?

Is there a kubectl command to go with psql?

Katlock · Accepted Answer · 2017-03-14 21:44:07Z

13

I was able to look at another forum and found what I needed. I executed with the pod name and gets me to a bash prompt.

kubectl exec -it  <POD_NAME> bash

answered Mar 14, 2017 at 21:44

Katlock

1,4182 gold badges24 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rafiq · Accepted Answer · 2021-05-28 07:19:11Z

3

kubctl get pods
kubectl exec -it  <POD_NAME> bash
su postgres
psql

in the above postgres is user name. you will get:

postgres=#

answered May 28, 2021 at 7:19

Rafiq

12k5 gold badges44 silver badges46 bronze badges