How to delete replication slot in postgres 9.4

Question

I have replication slot which I want to delete but when I do delete I got an error that I can't delete from view. Any ideas?

postgres=# SELECT * FROM pg_replication_slots ;   slot_name   |    plugin    | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn --------------+--------------+-----------+--------+----------+--------+------+--------------+-------------  bottledwater | bottledwater | logical   |  12141 | postgres | t      |      |       374036 | E/FE8D9010 (1 row)  postgres=# delete from pg_replication_slots; ERROR:  cannot delete from view "pg_replication_slots" DETAIL:  Views that do not select from a single table or view are not automatically updatable. HINT:  To enable deleting from the view, provide an INSTEAD OF DELETE trigger or an unconditional ON DELETE DO INSTEAD rule. postgres=# 

Answer 1

Use pg_drop_replication_slot:

select pg_drop_replication_slot('bottledwater'); 

See the docs and this blog.

The replication slot must be inactive, i.e. no active connections. So if there's a streaming replica using the slot you must stop the streaming replica. Or you can change its recovery.conf so it doesn't use a slot anymore and restart it.