DB 인사이드 PostgreSQL Replication - Slot

>> bharathrupireddyforpostgresgmailcom> wrote: >>> Currently postgres doesn't allow dropping a replication slot that's active

The function underlying pg_replication_slots reads the replication slot on-disk structures directly, meaning the contents of this view are always visible

postgresql replication slot pg_drop_replication_slot() is a system function for removing a physical or logical replication slot pg_drop_replication_slot() was added in PostgreSQL

postgresql drop replication slot Specifies the maximum number of replication slots that the server can support The default is 10