Schedule - pgDay Paris 2026
Synchronisation of logical replication slots
Date: 2026-03-26
Time: 14:25–15:10
Room: Karnak
Since the introduction of logical decoding, followed by integrated logical replication in version 10, it is possible to use PostgreSQL transaction logs to feed a logical replication stream. Until now, the reliability of the whole system depended on the use of a slot to store the progress of replication in the transaction logs.
But what happens when the instance holding this slot disappears? How can the slot be made fault-tolerant?
This is what we will discuss in this presentation. We will also focus on what PostgreSQL offers starting with version 17.