ZERO-DOWNTIME POSTGRES UPGRADES WITH LOGICAL REPLICATION

Summary from the TLDR Data newsletter

Logical replication offers a practical path to near-zero-downtime PostgreSQL major upgrades, with live rollback enabled by reverse replication. A Docker-based demonstration ran old and new clusters in parallel, freezing writes and waiting for replication to catch up before cutover. It achieved 181 ms of write interruption during upgrade and 179 ms during rollback, without data loss.