Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication
Presented by:
Nisha Moond
from
Fujitsu
Checkout the slides
- Enhancing High Availability: Failover slots in PostgreSQL-17 enable seamless continuation of logical replication during publisher node failure, with a promoted physical standby taking over as the new publisher.
- How Failover Slots Work:
- Fetching and synchronizing logical replication slot information from the primary to the standby.
- Manual synchronization using the pg_sync_replication_slots() function.
- Automatic synchronization via the slot-sync worker.
- Slot-Sync Worker: A detailed explanation of the slot-sync worker’s operational logic and how to handle synchronization challenges.
- Key Takeaway: Attendees will learn how to configure and utilize failover slots to maintain high availability in PostgreSQL deployments.
- Date:
- 2025 March 7 - 15:30
- Duration:
- 45 min
- Room:
- Grand Ballroom 1
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium
- Scaling Semantic Search in PostgreSQL : Indexing and Searching at Scale with pgvector
- Start Time:
- 2025 March 7 15:30
- Room:
- Grand Ballroom 2
- Sharded and Distributed Are Not the Same: What You Must Know When PostgreSQL Is Not Enough
- Start Time:
- 2025 March 7 15:30
- Room:
- Jupiter