Logical and Physical Replication

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

DROP REPLICATION SLOT replication_slot; CREATE REPLICATION SLOT replication_slot LOGICAL; Note: Make sure to replace replication_slot with

postgres drop replication slot We can have multiple replication slots for a single database; each slot has its own state allowing different consumers to receive changes from

postgres replication slot Postgres Logical Replication