Online Upgrade of replication clusters without downtime
summary
Explains a concrete, tested upgrade path that converts a streaming pair into a logical replication pair so one node upgrades with minimal downtime: set wal_level=logical, create publications and logical replication slots, run pg_create_subscriber on the standby to catch up and convert it (verification, catch‑up, replication setup), promote and upgrade the other node, then use PG17’s logical replication slot migration and preserved subscription relation metadata to avoid truncating tables or recreating subscriptions. Benchmarks show much faster conversion for large datasets.
AI-written summary · about
chapters (5)
- 0:00Introduction
- 13:48Upgrading streaming replication clusters
- 20:05Converting streaming clusters into logical ones
- 31:08Upgrading logical replication clusters
- 36:07Summary, Q&A
related talks
36mHow to Upgrade Replication Clusters without Downtime?
01h 41mPostgreSQL Upgrades with Logical Replication & Minimal Downtime
51mSpeeding up logical replication setup
01h 01mAlways Online or Bust
53mThe journey towards active replication in PostgreSQL
59mLogical Replication...LIVE!
50mAn ultimate guide to upgrading your PostgreSQL installation
49mHow we execute PG major upgrades at GitLab, with zero downtime.