Wieder was gelernt

Patroni and Replication Slots

2023-03-29 (Wednesday)
Tags: patroni postgresql

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 Alexander Kukushkin on pgsql-general Patroni Doc