PostgreSQL Logical Replication for selected tables with pg_dump

The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

Setup using CDC​ · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot

create logical replication slot postgres The recreation of replication slots gets enabled automatically for services created or updated as of January 2021 Additional details are outlined in our

create your own slot machine online free To turn on logical replication for a newly created RDS for PostgreSQL DB instance