Hacker News Reader

> Replication works across version differences, making upgrades without any downtime at all easier.

Postgres has logical replication these days, which can be used to achieve this

Except logical replication doesn't handle DDL yet. And 2 phase commit (prepared transactions) as well.

Two phase commit for logical replication is now available in Postgres 14.

The biggest issue I see at the moment is that sequences are not replicated.