Glossary — in plain language

Failover slot

Also called: failover-enabled slot

In plain English

A failover slot is a logical replication slot marked (with failover = true) to survive a failover. PostgreSQL 17 mirrors such slots onto a standby, so when that standby is promoted the logical subscribers’ bookmark already exists on the new primary at a safe position.

Why it matters

Before this, promoting a standby destroyed all logical slots, forcing subscribers and CDC pipelines to be re-seeded with the risk of gaps or duplicates. Marking a slot for failover makes logical replication survive a role change cleanly.

Was this helpful?

← Browse the full glossary