From: | Jaime Casanova <jaime(dot)casanova(at)2ndquadrant(dot)com> |
---|---|
To: | Dave Cramer <davecramer(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: This seems like very unfriendly behaviour |
Date: | 2019-05-26 05:40:38 |
Message-ID: | CAJGNTeMdh_L0+tSh9rXAVtsB2Ux7OfHuczp5u=Q6Ljv6EkupaQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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?
--
Jaime Casanova www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2019-05-26 06:12:30 | Why does pg_checksums -r not have a long option? |
Previous Message | David Rowley | 2019-05-25 23:00:41 | Re: Cleaning up and speeding up string functions |