CNPG Recipe 17 - PostgreSQL In-Place Major Upgrades
CloudNativePG 1.26 introduces one of its most anticipated features:
declarative in-place major upgrades for PostgreSQL using pg_upgrade
. This
new approach allows you to upgrade PostgreSQL clusters by simply modifying the
imageName
in their configuration—just like a minor version update. While it
requires brief downtime, it significantly reduces operational overhead, making
it ideal for managing large fleets of PostgreSQL databases in Kubernetes.
In this article, I will explore how it works, its benefits and limitations,
and cover an upgrade of a 2.2TB database.