Checking Whether the Specified Replication Slot Exists in

Here are some scenarios: When creating a subscription, the replication slot already exists In that case, the subscription can be created using the create_slot

A healthy secondary node exists and has caught up with WAL replication Name of the PostgreSQL replication slot used in the streaming replication setup

replication slot is active for pid A single replication slot can exist only for a single consumer or process

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