ERROR: all replication slots are in use

Diagnosing Jammed Replication The easiest problem to debug is a key violation: if an entry with a unique index already exists Postgres will log an error

If for example PostgreSQL Native Replication is already in use and is using all of the currently configured replication slots, increase the value to allow for

replication slot already exists You might already have this collection installed if you are using the ansible package Remove physical_one slot if exists become_user: postgres community

replication slot is active for pid Attempting to copy a logical replication slot when the destination slot already exists: replication slot test_slot_2 already exists Attempting to