Обсуждение: Can't drop logical replication slot

Поиск

Список

Период

Сортировка

От

Eduardo Gargiulo

Дата:

11 сентября 2023 г., 16:55:43

Hi all,

There is a logical replication slot I can't drop. Tried using

select pg_terminate_backend(PID) OK

select pg_drop_replication_slot('slot_name) OK

But the slot_name restarts with other active_pid. There is not subscriber connected and no errors in database log. We are using PG14.

Any help to drop or even rename replication slot would be appreciated.

Thanks in advance.

Eduardo