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)
Dave Cramer