PostgreSQL Logical Replication Gotchas

Logical Decoding Messages 101 Next, you need to create a replication slot A replication slot represents one specific stream of changes coming

In order to be able to ingest events from a Postgres database, Upsolver creates a replication slot for every CDC data source In Postgres

postgresql create replication slot 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

postgresql drop replication slot A replication slot is a PostgreSQL feature which ensures that a stream of changes stored in a WAL log file is replicated to the destination in the correct order