An ultimate guide to upgrading your PostgreSQL installation
summary
Covers concrete upgrade paths: pg_dump/restore (simple, double disk and downtime), pg_upgrade with hard links (seconds of downtime but risky, needs both old and new binaries, run pg_upgrade --check first), and replication approaches including logical replication requires primary keys and careful DDL control. Advises pgbackrest for backups, pgbouncer pause/resume to minimize downtime, enable checksums before v18, and always test recoveries and extension compatibility in a staging run.
AI-written summary · about
chapters (6)
- 0:00Introduction to upgrades
- 1:02Upgrade preparation guide
- 10:31Version types and methods
- 11:03Pg_upgrade and dump-restore
- 21:47Minimizing downtime
- 22:10Advanced topics and Q&A
related talks
46mAn ultimate guide to upgrading your PostgreSQL installation
01h 41mPostgreSQL Upgrades with Logical Replication & Minimal Downtime
01h 01mAlways Online or Bust
49mKeeping Up with the Times, or How to Upgrade PostgreSQL
32mPostgreSQL The Hard Way
59mPostgreSQL Don'ts and Dos
50mPostgreSQL Backup and Recovery Methods
26mMastering Large-Scale PostgreSQL Migration