Running PostgreSQL on Kubernetes · Day 2 Operations with CloudNativePG

Demo 4 — In-Place Major Upgrade, 17 → 18

One field. imageName 17 → 18, pg_upgrade --link, replicas re-cloned.

Beats

  1. 0:04One field. imageName 17 -> 18.
  2. 0:0804-major-upgrade.yaml on screen
  3. 0:13Operator shuts the cluster down and runs pg_upgrade --link i
  4. 0:27Replica PVCs are deleted + re-cloned from the upgraded prima
  5. 0:37Proof.
  6. 0:48PG 18 now preserves optimizer stats - but NOT extended stati
  7. 0:55And every base backup in the bucket is still PG 17 - it cann

Replay it locally

asciinema play -i 2 demos/demo4.cast  ·  download the cast