PostgreSQL Logical Replication

postgres create logical replication slot   Dan postgres drop replication slot

Create the Publication 14:41 - Create the Subscription 17:43

PostgreSQL 10 came with the welcome addition of the logical replication feature This provides a more flexible and easier means to replicate By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL

slot หวานเจี๊ยบ We can have multiple replication slots for a single database; each slot has its own state allowing different consumers to receive changes from A replication slot is the mechanism used in this scheme to track progress of a subscription For Aurora PostgreSQL DB clusters, the WAL records are saved on