title: Accessing database with pgAdmin in Kubernetes cluster
body: <p>In my current non-Kubernetes environment, if I need to access the Postgres database, I just setup an SSH tunnel with:</p>
  
  <p><code>ssh -L 5432:localhost:5432 user@domain.com</code></p>
  
  <p>I'm trying to figure out how to do something similar in a test Kubernetes cluster I am setting up in EKS, that doesn't involve a great security risk. For example, creating a path in the ingress control to the databases port is a <em>terrible</em> idea.</p>
  
  <p>The cluster would be setup where Postgres is in a pod, but all of the data is on persistent volume claim so that the data persists when the pod is destroyed.</p>
  
  <p>How would one use pgAdmin to access the database in this kind of setup?</p>