Aiven for PostgreSQL®: Automatic Recreation of Replication Slots

Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur

How it works When a logical replication slot is created, Postgres creates a snapshot of the current state of the database and records the consistent point

postgres create logical replication slot Options · --create-slot Create a new logical replication slot with the name specified by --slot , using the output plugin specified by --plugin , for the

postgres drop replication slot You must monitor logical decoding Any unused replication slot must be dropped Slots hold on to Postgres WAL logs and relevant system catalogs