Aiven for PostgreSQL®: Automatic Recreation of Replication Slots

A replication slot has an identifier that is unique across all databases in a PostgreSQL cluster Slots persist independently of the connection

The WAL location at which the slot became consistent This is the earliest location from which streaming can start on this replication slot snapshot_name

start replication slot postgres Replication slots are created independently from publications Publications to be used as a filter are specified when fetching changes stream

start 77 slot By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL