Patroni and Replication Slots

2023-03-29

Patroni sets use_slots: true by default, but it removes the slot 30 seconds after a member disappears, rendering it effectively useless.

The official(?) recommendation is to use continuous archiving (but then you don’t need slots either).

The (IMHO better) alternative is to configure permanent slots:

slots:
  nodename1:
    type: physical
  nodename2:
    type: physical
  nodename3:
    type: physical