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.