CloudNativePG

• Website
• GitHub
  • Golang
  • 6k stars, 160 contributors
• Official Helm chart
  • GitHub
• Docs

Setup

• Add a Cluster resource
• cnpg creates a secret <clustername>-app with cluster credentials (Defaults: username: app, dbname: app)

Major version upgrades

• Docs: Major version upgrades
• The Offline In-Place Major Upgrades method introducted in v1.26.0 (2025-06) seems to work fully automated
• But: Trying to upgrade a cluster from v13 to v14 resulted in:

  major upgrades are only supported to version 16 or higher

  • Upgrading from v13 to v16 worked !

Backup

• Backup
• Barman Cloud CNPG-I plugin
  • Docs

Cnpg plugin for kubectl

• Using the cnpg plugin for kubectl
• Kubectl Plugin

Install:

pamac install kubectl-cnpg

Cnpg plugin usage

• Docs: Usage:

kubectl -n varac get cluster
kubectl cnpg -n varac status cloudnative-pg-test

Hibernate:

kubectl cnpg -n vaultwarden hibernate on cloudnative-pg-vaultwarden
kubectl cnpg -n vaultwarden status cloudnative-pg-vaultwarden

Resume from hibernation:

kubectl cnpg -n vaultwarden hibernate off cloudnative-pg-vaultwarden

Usage

Connect to cluster to use psql:

kubectl -n umami exec -it cnpg-umami-1 -c postgres -- bash
  \l
  \c app
  \dt