Documentation: 16: Streaming Replication Protocol

A set of WAL records are reserved on the primary database when a replication slot is created The modifications made to the

Documentation: 16: Streaming Replication Protocol The slot state state=present implies the slot must be present in the system state=absent implies the groups must be revoked from target_roles

A set of WAL records are reserved on the primary database when a replication slot is created The modifications made to the

postgresql replication slot Replication is done through publications, a method of choosing which changes to send to other systems Publications can

Specify that this replication slot is a temporary one Temporary slots are not saved to disk and are automatically dropped on error or when the session has

postgres drop replication slot When dropping a subscription, the replication slot should be kept This could be useful when the subscriber database is being moved to a different host and will

NOTICE: created replication slot my_subscription on publisher CREATE SUBSCRIPTION From now on, all INSERT , UPDATE , and DELETE