On Tue, Mar 6, 2018 at 06:59:33PM +0530, tushar wrote: > Hi, > > I found that if server is running in single-user mode , there we can create > replication slot but cannot drop it . > > backend> SELECT * FROM pg_create_physical_replication_slot('p'); > 2018-03-06 13:20:03.441 GMT [14869] LOG: statement: SELECT * FROM > pg_create_physical_replication_slot('p'); > > 1: slot_name (typeid = 19, len = 64, typmod = -1, byval = f) > 2: lsn (typeid = 3220, len = 8, typmod = -1, byval = t) > ---- > 1: slot_name = "p" (typeid = 19, len = 64, typmod = -1, byval = f) > ---- > backend> select pg_drop_replication_slot('p'); > 2018-03-06 13:20:24.390 GMT [14869] LOG: statement: select > pg_drop_replication_slot('p'); > > 1: pg_drop_replication_slot (typeid = 2278, len = 4, typmod = -1, > byval = t) > ---- > 2018-03-06 13:20:24.391 GMT [14869] ERROR: epoll_ctl() failed: Bad file > descriptor > 2018-03-06 13:20:24.391 GMT [14869] STATEMENT: select > pg_drop_replication_slot('p');
I can confirm this bug exists in single-user mode. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +