Inside logical replication in PostgreSQL: How it works

Each subscription will receive changes via one replication slot Additional replication slots may be required for the initial data

Replication slots for High Availability A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby

postgres create logical replication slot While using the PostgreSQL Logical Replication Slots, we must be careful enough at the WAL file size as an orphaned slot, or inactive slot, or a

postgres 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