Re: This seems like very unfriendly behaviour

2019-05-26 Thread Andres Freund
Hi, On May 26, 2019 9:49:49 AM EDT, Dave Cramer wrote: >On Sun, 26 May 2019 at 01:40, Jaime Casanova > >wrote: > >> On Sat, 25 May 2019 at 08:35, Dave Cramer >wrote: >> > >> > How do I get rid of this slot ? >> > >> > select pg_drop_replication_slot('mysub'); >> > ERROR: replication slot

Re: This seems like very unfriendly behaviour

2019-05-26 Thread Dave Cramer
On Sun, 26 May 2019 at 01:40, Jaime Casanova wrote: > On Sat, 25 May 2019 at 08:35, Dave Cramer 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

Re: This seems like very unfriendly behaviour

2019-05-25 Thread Jaime Casanova
On Sat, 25 May 2019 at 08:35, Dave Cramer 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

This seems like very unfriendly behaviour

2019-05-25 Thread Dave Cramer
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