PostgreSQL Logical Replication for selected tables with pg_dump

PostgreSQL Logical Replication for selected tables with pg_dump create replication slot postgres While working on a demo for processing change events from Postgres with Apache Flink, I noticed an interesting phenomenon: A Postgres create replication slot When creating a subscription, the replication slot already exists In that case, the subscription can be created using the create_slot = false option to

create replication slot Publication slots configuration involves using the Create Replication Slot command in PostgreSQL to establish a slot dedicated to publishing data This

create replication slot postgres The max_replication_slots configuration parameter defines the maximum number of replication slots that can be used to manage database created replication slot mysub on publisher CREATE SUBSCRIPTION The changes are synced, and you can see the rows at the destination side