CNPG Workshop for DevOps Days Amsterdam 2025

Create a kind Cluster from CNPG Playground

kind create cluster --config k8s/kind-cluster.yaml

Export Kube config file (inside CNPG Playground repo)

export KUBECONFIG=./k8s/kube-config.yaml

Install the Kubectl Plugin for CNPG

curl -sSfL \
  https://github.com/cloudnative-pg/cloudnative-pg/raw/main/hack/install-cnpg-plugin.sh | \
  sudo sh -s -- -b /usr/local/bin

Install the CNPG Operator using the CNPG Plugin

kubectl cnpg install generate --control-plane \
  | kubectl apply -f - --server-side

Create a Cluster YAML file

cat <<EOF > ./cluster-example.yaml
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: cluster-example
spec:
  instances: 3

  storage:
    size: 1Gi
EOF

Deploy the cluster-example Cluster

kubectl apply -f cluster-example.yaml

Check the cluster's status with CNPG Plugin

kubectl cnpg status cluster-example

Exec into the CNPG Pod

kubectl exec -ti cluster-example-1 -c postgres -- bash

Connect to the databse with exec

kubectl exec -ti cluster-example-1 -c postgres -- psql -c '\du' -c '\l'

Connect to the databse with CNPG Plugin

kubectl cnpg psql cluster-example -- -c '\du' -c '\l'

Reading logs

kubectl logs cluster-example-1

Reading logs with CNPG Plugin

kubectl cnpg logs cluster cluster-example -f \
  | kubectl cnpg logs pretty

Scaling up the cluster

kubectl scale cluster cluster-example --replicas 4

Scaling down the cluster

kubectl scale cluster cluster-example --replicas 3

ArgoCD

kubectl create namespace argocd

kubectl apply -n argocd -f \
  https://raw.githubusercontent.com/argoproj/argo-cd/stable/manifests/install.yaml

Forward ArgoCD Port

kubectl port-forward svc/argocd-server \
  -n argocd 8080:443

Set password

argocd admin initial-password -n argocd

Login

argocd login --username admin localhost:8080

Deploy CNPG with ArgoCD

argocd app create cloudnativepg \
  --repo https://github.com/sxd/cloudnative-pg-argocd.git \
  --path install-operator-argocdapp \
  --dest-server https://kubernetes.default.svc \
  --dest-namespace default

argocd app sync cloudnativepg
argocd app list

Deploy and manage CNPG Cluster

argocd app create cnpg-clusters \
  --repo https://github.com/sxd/cloudnative-pg-argocd.git \
  --path clusters \
  --dest-server https://kubernetes.default.svc \
  --dest-namespace default

argocd app sync cnpg-clusters
argocd app sync cloudnative-pg-clusters
kubectl -n cnpg-samples get pods -w

Links

CNPG Playground

GitHub: https://github.com/cloudnative-pg/cnpg-playground
Single Cluster: https://github.com/cloudnative-pg/cnpg-playground?tab=readme-ov-file#single-kubernetes-cluster-setup

CloudNativePG

GitHub: https://github.com/cloudnative-pg/cloudnative-pg
Docs: https://cloudnative-pg.io/documentation/current/
Kubectl Plugin: https://cloudnative-pg.io/documentation/current/kubectl-plugin/#install
Quick Start: https://cloudnative-pg.io/documentation/current/quickstart/#part-3-deploy-a-postgresql-cluster
Reading Logs: https://cloudnative-pg.io/documentation/current/troubleshooting/#logs
Services: https://cloudnative-pg.io/documentation/current/architecture/#read-write-workloads
PG Config: https://cloudnative-pg.io/documentation/current/postgresql_conf/
Special PG Parameters: https://www.postgresql.org/docs/current/hot-standby.html#HOT-STANDBY-ADMIN
Failure: https://cloudnative-pg.io/documentation/current/failure_modes/#failure-modes_1

ArgoCD

Manifest: https://raw.githubusercontent.com/argoproj/argo-cd/stable/manifests/install.yaml
Repo: https://github.com/sxd/cloudnative-pg-argocd.git