Aiven for PostgreSQL®: Automatic Recreation of Replication Slots

Aiven for PostgreSQL®: Automatic Recreation of Replication Slots replication slot postgres Unfortunately, PostgreSQL does not provide a direct function or view that shows the size of the replication slot in terms of disk space However, you can replication slot Physical slots are created automatically based on replica hosts and used for data replication within the Managed Service for PostgreSQL cluster

replication slot Replication slots are a persistent data structure used to track the progress of replication across subscribers, and to ensure that WAL data

replication slot already exists A replication slot is a feature in PostgreSQL that ensures that the master server will retain the WAL logs that are needed by the replicas Take Away The morale of the story? Don't leave your replication slots unattended! There shouldn't be any slots which are inactive for too long