Implementing failover of logical replication slots in Patroni

Application of replication slots in PostgreSQL postgres replication slot In the context of PostgreSQL's logical replication, a “slot” is a mechanism used to keep track of the replication stream's progress Logical postgresql drop replication slot The slot to be dropped must be inactive before it can be removed It is not possible to forcibly drop an active replication slot Change history PostgreSQL

postgres create logical replication slot Answer If you do not see the replication slot under the slot_name column then the slot does not exist There are two potential reasons for this: If you do