ERROR: all replication slots are in use

ERROR: all replication slots are in use postgres delete replication slot The replication slot basically tells Postgres not to recycle or remove any WAL files that could ultimately prevent it from catching up with postgresql drop replication slot catalog_xmin, xid, The oldest transaction affecting the system catalogs that this slot needs the database to retain VACUUM cannot remove catalog tuples deleted

postgresql drop replication slot Starting from PostgreSQL , it is also necessary and useful to check for leftover replication slots The core issue is that if somebody forgets to drop a

postgres delete replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be Fixing PostgreSQL database replication errors · Removing an inactive replication slot · Message: WARNING: oldest xmin is far in the past and pg_wal size growing