PostgreSQL Version Upgrade

Plan your PostgreSQL major version upgrade the right way — in-place with pg_upgrade, or out-of-place with near-zero downtime.

Description

Major version upgrades are one of the riskiest routine operations a DBA runs — and most failures come from skipped validation, not the tooling. This session is built specifically around pg_upgrade and the two ways to run it: fast in-place upgrades on a single server, and safer out-of-place upgrades that support near-zero-downtime cutover.

We'll figure out which path fits your environment, walk through the pre-checks that actually matter, and build a rollback plan so you're never upgrading without a way back.