Postgres logical replication concepts

Postgres logical replication concepts postgres create logical replication slot This is an example using wal2json A replication slot must be created on the PostgreSQL server SELECT * FROM postgresql create replication slot As mentioned earlier, each subscription receives changes from a replication slot on the remote side Additional table

postgresql create replication slot Logical Replication on Standbys in Postgres 16 · create logical decoding from a read-only standby · reduce the workload on the primary server

postgres replication slot By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL  Replication slots were introduced in Postgres They are a mechanism to accurately and durably keep track of how far a standby is lagging behind the primary