Keeping Up with the Times, or How to Upgrade PostgreSQL
summary
How to perform PostgreSQL version upgrades in production, covering the challenges of upgrading a critical primary data store. The talk discusses practical upgrade strategies and operational considerations for minimizing risk when migrating PostgreSQL in high-load systems.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 2:34Major vs minor updates
- 7:30Minor update method
- 15:11Major update methods
- 22:16Preparing for pg_upgrade
- 29:46Completing pg_upgrade
- 37:11Extension and replica updates
- 40:20Logical replication for upgrades
- 43:10Summary and tips
related talks
50mAn ultimate guide to upgrading your PostgreSQL installation
46mAn ultimate guide to upgrading your PostgreSQL installation
26mMastering Large-Scale PostgreSQL Migration
01h 41mPostgreSQL Upgrades with Logical Replication & Minimal Downtime
32mPostgreSQL Major Upgrades: Swapping the Elephant Without Breaking the Room
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
01h 01mAlways Online or Bust
36mPostgreSQL: Ups, DevOps...
