Implementing failover of logical replication slots in Patroni

Implementing failover of logical replication slots in Patroni replication slot As the commit log already mentions, replication slots have the possibility to be made temporary When created, they are associated with the replication slot does not exist replication slots while creating replication slot for Postgres source in DBMI replication slot and retry the replication slot again

replication slot does not exist Take Away The morale of the story? Don't leave your replication slots unattended! There shouldn't be any slots which are inactive for too long

replication slot postgres Learn how to troubleshoot replication slot errors  SELECT * FROM pg_replication_slots to see if any replication slots were accidentally created that might be preventing WAL cleanup SHOW