Documentation: 16: Chapter 31 Logical Replication
Documentation: 16: Chapter 31 Logical Replication
Setup using CDC · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot
The beauty of Postgres logical replication is that not only other Postgres instances can serve as the consumer of a replication stream, Create a logical replication slot on a standby node · Create a SUBSCRIPTION to a standby node · Create logical decoding from a read-only standby
slot machine winner We can have multiple replication slots for a single database; each slot has its own state allowing different consumers to receive changes from Drops a replication slot, freeing any reserved server-side resources If the slot is a logical slot that was created in a database other than the database the