Postgres logical replication beyond one writer
Comments
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Summary
Dimitri Fontaine builds a five-region, multi-writer Postgres system, the kind BDR targeted in 2014, from Postgres 19 RC1 logical replication and pg_auto_failover. In his tests, killing primaries under load lost no acknowledged rows when synchronized_standby_slots was set correctly, though a killed primary blocked its writer for about 51 seconds. Core still lacks DDL replication, conflict resolution and multi-writer ids, so he avoids conflicts through region-keyed rows and handles schema changes with a short write pause. The results come from his own lab runs.