PostgreSQL

Let's see how to run PostgreSQL (code) in a Kubernetes cluster.

Configuration

We'll use the Bitnami's Helm chart (code):

• values.yaml

Deployment

# adds Helm chart repository
helm repo add bitnami https://charts.bitnami.com/bitnami
helm repo update

# installs
helm upgrade --install postgresql bitnami/postgresql  --namespace postgresql --create-namespace

# checks everything is ok
kubectl get pod -n postgresql

# uninstalls
helm uninstall reportportal -n reportportal
kubectl delete ns reportportal

Examples

Minimal installation with default parameters and fixed password

Install the application:

helm upgrade --install postgresql bitnami/postgresql --namespace postgresql --create-namespace \
  --set postgresql.auth.postgresPassword=secretpassword

Forward the service port for local access:

kubectl port-forward service/postgresql 5432:5432 -n postgresql

Use pgAdmin to access the service on localhost:5432 and log in with postgres/secretpassword.