PostgreSQL 14 to 18 upgrade
Upgrading off PostgreSQL 14 before its November 12, 2026 end of life straight to PostgreSQL 18: pg_upgrade --check, extension compatibility, MD5 to SCRAM password changes, and rehearsing the cutover.
PostgreSQL upgrades
Planning PostgreSQL major version upgrades, including the PostgreSQL 14 end of life and the choice between pg_upgrade and logical replication.
PostgreSQL major upgrade with pg_upgrade or logical replication
Choosing the major upgrade method by downtime budget: pg_upgrade copy, link, clone and swap modes versus a logical replication cutover measured in seconds, with the rollback options each one leaves.
