Seamless Postgres Upgrades Via Logical Replication

2026-10-13

This article details how to perform PostgreSQL major-version upgrades without service interruption by utilizing logical replication. It covers methods like in-place upgrades with pg_upgrade, recovery options such as pg_dump and pgcopydb, and ongoing migration strategies including reverse subscriptions and marker rows, aiming for write stalls under 200 milliseconds.