PostgreSQL replication slot

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

postgresql_slot module

postgres create replication slot Replication slots are used to safeguard against the premature deletion of WAL segments before they have been applied by the standby server, thus

postgres drop replication slot It is important to remove unused replication setups, since the underlying replication slots in PostgreSQL forces the server to keep all the data needed to