pg_failover_slots: The missing piece
summary
pg_failover_slots is an open source plugin released this year that synchronizes logical replication slots across physical failover by running as a background worker plugin, copying slot names and LSNs from primary to standby and letting standbys refuse to advance past a chosen physical target via the standby_slot_names setting. It supports Postgres 11–16, installs from packages, handles slot filtering and automatic drops, has low overhead in production, and works today, but needs orchestration and monitoring to avoid blocking or data-gap risk.
AI-written summary · about
chapters (8)
- 0:00The replication challenge
- 4:46Replication slot limitations
- 6:46Evolution of slot management
- 10:27Introducing PG failover slots
- 20:01The second replication issue
- 25:44Advanced configuration
- 29:36Conclusion and future work
- 36:11Q&A session
related talks
37mFailover Slots in PostgreSQL-17:
02h 26mTutorial
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
53mThe journey towards active replication in PostgreSQL
50mMoving from MSSQL to pgSQL – High Availability and Disaster Recovery
36mHow to Upgrade Replication Clusters without Downtime?
52mNew Data Replication Technologies in PostgreSQL
51mPostgreSQL Replication Conflicts: Avoiding Pitfalls