Postgres OperatorGet Postgres up and running on your Kubernetes cluster

Connect Directly

This is obviously the easiest method to connect, but it only works if you are on the same network as the Postgres Cluster.

psql $(kubectl -n postgres-operator get secrets hippo-pguser-hippo -o go-template='{{.data.uri | base64decode}}')

Connect using Port-Forward (shown in terminal)

If you are not on the same network, then we will need to use a port-forward to connect.

1. Create variable for pod

   PG_CLUSTER_PRIMARY_POD=$(kubectl get pod \  -n postgres-operator \  -o name \  -l postgres-operator.crunchydata.com/cluster=hippo,postgres-operator.crunchydata.com/role=master)

2. Create port-forward

   kubectl -n postgres-operator port-forward "${PG_CLUSTER_PRIMARY_POD}" 5432:5432

3. Create variables for connection details

   PGPASSWORD=$(kubectl get secrets -n postgres-operator "hippo-pguser-hippo" -o go-template='{{.data.password | base64decode}}') \PGUSER=$(kubectl get secrets -n postgres-operator "hippo-pguser-hippo" -o go-template='{{.data.user | base64decode}}') \PGDATABASE=$(kubectl get secrets -n postgres-operator "hippo-pguser-hippo" -o go-template='{{.data.dbname | base64decode}}')

4. Connect to database

   psql -h localhost