Patroni missed creating the replication slot for the nodes in the cluster

Configure the primary database · Configure replication parameters · Create replication slots · Configure host-based authentication parameters · Create a base backup

Then get a session on the database and create a replication slot like this: 1 2 3 4 5 6, SELECT * FROM pg_create_logical_replication_slot

create replication slot postgres Resolution · Turn on logical replication · Connect to source database in source DB instance · Create a publication for source tables · Connect to target database

create replication slot created replication slot my_sub on publisher CREATE SUBSCRIPTION Now, verify the existing row has been replicated: postgres=#