Implementing failover of logical replication slots in Patroni

manually create replication slot for publication in PostgreSQL 10 postgres create logical replication slot PostgreSQL Logical Replication basic concepts · Publication: A set of changes from a set of tables defined in a specific database on a physical postgresql drop replication slot The postgresql_replication_slot resource creates and manages a replication slot on a PostgreSQL server database

postgres replication slot created replication slot sub1 on publisher CREATE SUBSCRIPTION mydbops=# On node1: mydbops=# create subscription sub2 CONNECTION 'host