access postgres in kubernetes from an application outside the cluster

Question

Am trying to access postgres db deployed in kubernetes(kubeadm) on centos vms from another application running on another centos vm. I have deployed postgres service as 'NodePort' type. My understanding is we can deploy it as LoadBalancer type only on cloud providers like AWS/Azure and not on baremetal vm. So now am trying to configure 'ingress' with NodePort type service. But am still unable to access my db other than using kubectl exec $Pod-Name on kubernetes master.

My ingress.yaml is

apiVersion: networking.k8s.io/v1beta1
kind: Ingress
metadata:
  name: postgres-ingress
spec:
  backend:
    serviceName: postgres
    servicePort: 5432

which does not show up any address as below

NAME                    HOSTS   ADDRESS    PORTS   AGE
postgres-ingress        *                  80      4m19s

am not even able to access it from pgadmin on my local mac. Am I missing something?

Any help is highly appreciated.

and how did you access the database? Its just a service and no ingress, that means not reachable from outside the cluster. Best regards Falk — Falk
– Falk, Commented Jul 25, 2024 at 10:51

Dirbaio · Accepted Answer · 2020-02-03 23:22:28Z

25

Ingress won't work, it's only designed for HTTP traffic, and the Postgres protocol is not HTTP. You want solutions that deal with just raw TCP traffic:

A NodePort service alone should be enough. It's probably the simplest solution. Find out the port by doing kubectl describe on the service, and then connect your Postgres client to the IP of the node VM (not the pod or service) on that port.
You can use port-forwarding: kubectl port-forward pod/your-postgres-pod 5432:5432, and then connect your Postgres client to localhost:5432. This is my preferred way for accessing the database from your local machine (it's very handy and secure) but I wouldn't use it for production workloads (kubectl must be always running so it's somewhat fragile and you don't get the best performance).
If you do special networking configuration, it is possible to directly access the service or pod IPs from outside the cluster. You have to route traffic for the pod and service CIDR ranges to the k8s nodes, this will probably involve configuring your VM hypervisors, routers and firewalls, and is highly dependent on what networking (CNI) plugin are you using for your Kubernetes cluster.

answered Feb 3, 2020 at 23:22

Dirbaio

3,16021 silver badges15 bronze badges

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

4 Comments

Naser Mirzaei Over a year ago

Also LoadBalancer service works as a solution. But it's a bit expensive :D

PassionateDeveloper Over a year ago

Do you have an example @NaserMirzaei

Naser Mirzaei Over a year ago

@PassionateDeveloper kubernetes.io/docs/concepts/services-networking/service/…

Masoud Ehteshami Over a year ago

Is there any way to use Ingress with the domain record?

klaudiusnaban · Accepted Answer · 2023-06-18 06:24:36Z

3

for me, it worked by adding nodePort type service

apiVersion: v1
kind: Service
metadata:
  name: postgresql-external
  labels:
    version: 1.0.0
spec:
  selector:
    sfs: postgresql-sfs
  ports:
    - name: postgresql-external
      port: 5432
      targetPort: 5432
      nodePort: 30030
  type: NodePort

don't forget to change the selector. Mine was targeted to the postgres' statefulset.

answered Jun 18, 2023 at 6:24

klaudiusnaban

3062 silver badges10 bronze badges

Comments

Mircea Sirghi · Accepted Answer · 2024-10-22 16:50:49Z

0

Just change postgres service type to LoadBalancer, add port 5432 to ingress, and open the tunnel, for minikube it would be:

minikube tunnel

answered Oct 22, 2024 at 16:50

Mircea Sirghi

6485 silver badges14 bronze badges

Collectives™ on Stack Overflow

access postgres in kubernetes from an application outside the cluster

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related