From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org,Dave Cramer <davecramer(at)gmail(dot)com>,Jaime Casanova <jaime(dot)casanova(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: This seems like very unfriendly behaviour |
Date: | 2019-05-26 15:23:46 |
Message-ID: | 4507A255-D178-467B-93FD-99421CCD7054@anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Lakhin | 2019-05-26 15:43:41 | Re: Fix typos for v12 |
Previous Message | sharon clark | 2019-05-26 14:50:00 | Re: GSoD Introductory Resources and Tutorial Projects |