Presented by:

27feecc8126c5dac7f2323d185141433

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