Postgres logical replication concepts

Store replication slot name , type , plugin , database and datoid If PostgreSQL version is 10 or newer also store catalog_xmin and confirmed_flush_lsn When

Replication slots are marked as 'inactive' when the replication client connected to the slot disconnects Inactive replication slots cause WAL files to be

postgres drop replication slot Answer If you do not see the replication slot under the slot_name column then the slot does not exist There are two potential reasons for this: If you do

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