How Do I Manually Delete Replication Slots from a PostgreSQL Data Source?

Symptom

The replication slots of the PostgreSQL data source cannot be automatically deleted. When the number of replication slots reaches the upper limit, new jobs cannot be executed. You must manually delete replication slots.

Possible Cause

The replication slots of the PostgreSQL data source cannot be automatically deleted.

Solution

1. Log in to the source database used by the job.
2. Query the name of the streaming replication slot corresponding to the database object selected for the synchronization task.

   select slot_name from pg_replication_slots where database = 'database';

3. Run the following statement to delete the corresponding streaming replication slot:

   select * from pg_drop_replication_slot('slot_name');

4. Run the following statement to check whether the streaming replication slot is deleted:

   select slot_name from pg_replication_slots where slot_name = 'slot_name';