Inside logical replication in PostgreSQL: How it works

Inside logical replication in PostgreSQL: How it works drop replication slot postgres postgresql_slot module drop slot safes The slot state state=present implies the slot must be present in the system state=absent implies the groups must be revoked from target_roles

drop slot safes True if this is a temporary replication slot Temporary slots are not saved to disk and are automatically dropped on error or when the session has finished

drops of gold slot This simply introduces two new options allowing to create or drop a physical replication slot, respectively –create-slot and –drop-slot The The replication slot basically tells Postgres not to recycle or remove any WAL files that could ultimately prevent it from catching up with