TLDR Data · OPINIONS & ADVICE

TEN YEARS OF POSTGRES LOGICAL REPLICATION

tapoueh.org16 min read

Summary from the TLDR Data newsletter

Postgres logical replication has steadily replaced custom data-movement plumbing with core SQL features: row filters, column lists, partitioned targets, streaming apply, parallel apply, and safer loop prevention. This retrospective connects those releases to practical migration and hub-and-worker scaling patterns. It is a useful checklist for teams revisiting replication slots, failover, write routing, and schema evolution.