Configuring PostgreSQL CDC Replication Slots and Publications

postgresql_replication_slot Resources create replication slot Setup using CDC​ · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot create your own slot machine online free pg_create_logical_replication_slot() is a system function for creating a logical replication slot pg_create_logical_replication_slot() was added in PostgreSQL

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