The Insatiable Postgres Replication Slot

The Insatiable Postgres Replication Slot replication slot Represents a physical replication connection to a PostgreSQL server PhysicalReplicationSlot Wraps a replication slot that uses physical replication replication slot is active for pid Unused slots can be dropped to remove WAL segments using the pg_drop_replication_slot command There generally is one replication slot and WAL sender per

replication slot is active for pid Create a replication slot on your Postgres database; Create publication and replication identities for each Postgres table; Enable CDC replication in the

replication slot postgres It's about 10 tables in the schema, so that means 11 replication slots per subscriber cluster So in production could be up to 99 slots, let's replication slot, then switches over and deletes the old replication slot when done The replication slots can be viewed using this query: