Helm/PostgreSQL

helm repo add bitnami https://charts.bitnami.com/bitnami
helm repo update && helm repo list

Config

export KUBECONFIG="${HOME}/.kube/dev-kubeconfig.yaml"
export KUBECONFIG="${HOME}/.kube/gcp-kubeconfig.yaml"
export KUBECONFIG="${HOME}/.kube/config"

Install

helm show values bitnami/postgresql --version=15.5.20|less helm show values bitnami/postgresql --version=15.5.21|less	kubectl get ns|grep postgresql kubectl delete ns postgresql	kubectl get ns|grep postgresql kubectl create ns postgresql
cat <<YML | helm -n postgresql install postgresql bitnami/postgresql --version=15.5.21 -f - --- global: storageClass: standard postgresql: auth: postgresPassword: sadaqah! username: academia password: sadaqah! database: academia primary: initdb: scripts: init-chorke.sql: | -- create database CREATE DATABASE academia_flair_staging; CREATE DATABASE academia_audit_staging; CREATE DATABASE academia_quote_staging; CREATE DATABASE academia_users_staging; -- create user CREATE USER chorke WITH ENCRYPTED PASSWORD 'sadaqah!'; ALTER USER chorke WITH SUPERUSER; -- grant access GRANT ALL PRIVILEGES ON DATABASE academia_flair_staging TO chorke; GRANT ALL PRIVILEGES ON DATABASE academia_audit_staging TO chorke; GRANT ALL PRIVILEGES ON DATABASE academia_quote_staging TO chorke; GRANT ALL PRIVILEGES ON DATABASE academia_users_staging TO chorke; YML
psql -h psql.k8s.local -p 5432 -U academia academia psql -h psql.k8s.local -p 5432 -U postgres postgres	psql 'postgres://academia:@psql.k8s.local:5432/academia' psql 'postgres://postgres:@psql.k8s.local:5432/postgres'

Patch

kubectl -n postgresql get sts/postgresql -ojson|jq -r '.spec.template.spec.nodeSelector'
cat <<YML | kubectl -n postgresql patch sts/postgresql --patch-file=/dev/stdin --- spec: template: spec: nodeSelector: topology.kubernetes.io/zone: minikube YML	cat <<YML | kubectl -n postgresql patch sts/postgresql --patch-file=/dev/stdin --- spec: template: spec: nodeSelector: topology.kubernetes.io/zone: ap-southeast-1a YML
kubectl -n postgresql get sts/postgresql -ojson|jq -r '.spec.template.spec.nodeSelector' kubectl -n postgresql delete pods --all

Uninstall

helm uninstall -n postgresql postgresql
kubectl delete namespace postgresql

Swiss Knife

kubectl -n postgresql run -i --tty --rm psql --image=alpine --restart=Never -- sh
apk --update add postgresql-client inetutils-telnet

psql -d postgres -U postgres -h postgresql.postgresql.svc.cluster.local
psql -d postgres -U postgres -h postgresql.postgresql.svc
psql -d postgres -U postgres -h postgresql.postgresql
psql -d postgres -U postgres -h postgresql

Playground

helm -n postgresql install postgresql bitnami/postgresql --version=15.5.20 helm -n postgresql upgrade -i postgresql bitnami/postgresql --version=15.5.21 helm show values bitnami/postgresql --version=15.5.21|less
kubectl -n postgresql get secret postgresql -o json|jq -r '.data."postgres-password"'|base64 -d;echo kubectl -n postgresql get secret postgresql -o json|jq -r '.data.password'|base64 -d;echo kubectl -n postgresql exec -it svc/postgresql -c postgresql -- psql -Upostgres kubectl -n postgresql exec -it svc/postgresql -c postgresql -- bash kubectl -n postgresql exec -it svc/postgresql -- psql -Upostgres
kubectl config --kubeconfig=${HOME}/.kube/aws-kubeconfig.yaml view --flatten kubectl config --kubeconfig=${HOME}/.kube/dev-kubeconfig.yaml view --flatten kubectl config --kubeconfig=${HOME}/.kube/gcp-kubeconfig.yaml view --flatten kubectl config --kubeconfig=${HOME}/.kube/config view --flatten
kubectl -n postgresql delete all --all kubectl -n postgresql delete ing --all kubectl -n postgresql delete sts --all	kubectl -n postgresql delete svc --all kubectl -n postgresql delete pvc --all kubectl -n postgresql delete pv --all
kubectl -n postgresql rollout history sts postgresql kubectl -n postgresql rollout restart sts postgresql kubectl -n postgresql rollout status sts postgresql	kubectl -n postgresql exec -it postgresql-0 -- psql -Upostgres kubectl -n postgresql logs -f svc/postgresql -c postgresql kubectl -n postgresql logs -f svc/postgresql

References

Helm » Pass YAML/JSON using stdin Helm » PostgreSQL » Quick Start Helm » PostgreSQL » Init Script Helm » PostgreSQL » Install Helm » Prometheus Stack Helm » Cert Manager Helm » PostgreSQL Helm
PostgreSQL » Bitnami » Helm Charts » HA PostgreSQL » Bitnami » Helm Charts PostgreSQL » Bitnami » Package PostgreSQL » Dockerized PostgreSQL
K8s » Configure Service Accounts for Pods K8s » Restart Pods With Kubectl K8s » Interactive Pod K8s » Restart Pods Docker » Makefile Kubernetes Minikube Kubectl CURL K8s	K8s » kubectl rollout K8s » CSI Hostpath Driver K8s » Ingress MinIO CIDR UFW