Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication
Presented by:
Nisha Moond
from
Fujitsu
No video of the event yet, sorry!
- 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:
- Duration:
- 45 min
- Room:
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium