Failover Slots in PostgreSQL-17:

on YouTube ↗37m

" summary

PostgreSQL 17 adds real‑time replication of selected logical slots to the standby so subscribers can resume without full resync; configure slots with failover=true (or pass failover to pg_create_logical_replication_slot), enable standby settings like primary_slot_name and hot_standby_feedback, and run the manual sync function PG_sync_replication_slots or enable the background worker via sync_replication_slots. Sync cycles run at least every 200 ms (backing off to 30 s), synced slots are read‑only on standby and temporary slots are dropped; table copy restarts if it was mid‑copy.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 0:25Logical replication overview
3. 9:25Problem during failover
4. 12:53Failover slots in PG17
5. 14:21Configuring failover slots
6. 17:49Manual slot synchronization
7. 21:01Automatic slot synchronization
8. 24:13Reducing downtime in PG17
9. 27:25Verifying failover readiness
10. 30:57Summary and limitations
11. 31:40Q&A

" related talks

• 43mpg_failover_slots: The missing piecePeter Eisentraut · PostgreSQL Conference Europe 2023
• 43mPostgreSQL 17 and beyondAmit Kapila · PGConf.dev 2024
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 53mThe journey towards active replication in PostgreSQLJonathan S. Katz, Amit Kapila · PGCon 2023
• 48mReplication RefreshSimon Riggs · PostgresOpen 2013
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Live 2022
• 42mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · PGConf NYC 2022