Implementing failover of logical replication slots in Patroni
Implementing failover of logical replication slots in Patroni
Creating a base backup Then, we need to make sure the data directory is empty In that case, the replica will fail unless there is a replication slot
The slot cannot be created as you are connected to a replica Common cloud implementations of PostgreSQL do not allow the addition of logical slots on replicas Learn how to use replication slots with PostgreSQL's streaming physical replication failure sudo systemctl stop postgresql@10-main # promote replica sudo
burning sun slot If the replication lag is high, WAL log playback on the replica is slower than log generation on the primary instance, so data cannot be The PostgreSQL replication slot used by the Pipeline is not able to complete the IO event WALRead, and is waiting for data to be read from the
![Implementing failover of logical replication slots in Patroni](10043.jpg)