Re: This seems like very unfriendly behaviour

Hi,

On May 26, 2019 9:49:49 AM EDT, Dave Cramer <davecramer(at)gmail(dot)com> wrote:
>On Sun, 26 May 2019 at 01:40, Jaime Casanova
><jaime(dot)casanova(at)2ndquadrant(dot)com>
>wrote:
>
>> On Sat, 25 May 2019 at 08:35, Dave Cramer <davecramer(at)gmail(dot)com>
>wrote:
>> >
>> > How do I get rid of this slot ?
>> >
>> > select pg_drop_replication_slot('mysub');
>> > ERROR: replication slot "mysub" is active for PID 13065
>> > test_database=# select * from pg_subscription;
>> > subdbid | subname | subowner | subenabled | subconninfo |
>subslotname |
>> subsynccommit | subpublications
>> >
>>
>---------+---------+----------+------------+-------------+-------------+---------------+-----------------
>> > (0 rows)
>> >
>> > test_database=# select * from pg_publication;
>> > pubname | pubowner | puballtables | pubinsert | pubupdate |
>pubdelete |
>> pubtruncate
>> >
>>
>---------+----------+--------------+-----------+-----------+-----------+-------------
>> > (0 rows)
>> >
>>
>> Can you check "select * from pg_stat_replication"?
>>
>> also, what pid is being reported in pg_replication_slot for this
>slot?
>> do you see a process in pg_stat_activity for that pid? in the os?
>>
>
>Well it turned out it was on receiver. I did get rid of it, but still
>not a
>friendly message.

What behavior would you like? It's similar to how we behave with dropping databases, roles etc.

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.