Re: cannot drop replication slot if server is running in single-user mode

2018-05-08 Thread Alvaro Herrera
Alvaro Herrera wrote: > Robert Haas wrote: > > On Thu, Mar 29, 2018 at 5:51 PM, Andres Freund wrote: > > >> > 2018-03-06 13:20:24.391 GMT [14869] ERROR: epoll_ctl() failed: Bad > > >> > file > > >> > descriptor > > >> > > >> I can confirm this bug exists in single-user mode. > > > > > > I'm not

Re: cannot drop replication slot if server is running in single-user mode

2018-05-08 Thread Alvaro Herrera
Robert Haas wrote: > On Thu, Mar 29, 2018 at 5:51 PM, Andres Freund wrote: > >> > 2018-03-06 13:20:24.391 GMT [14869] ERROR: epoll_ctl() failed: Bad file > >> > descriptor > >> > >> I can confirm this bug exists in single-user mode. > > > > I'm not sure we need to do anything about this, personal

Re: cannot drop replication slot if server is running in single-user mode

2018-05-08 Thread Tom Lane
Robert Haas writes: > On Thu, Mar 29, 2018 at 5:51 PM, Andres Freund wrote: >> I'm not sure we need to do anything about this, personally. This seems >> like a fairly rare thing to do in a mode that's definitely not intended >> to be general purpose. > Mmmph. I don't really think it's possible

Re: cannot drop replication slot if server is running in single-user mode

2018-05-08 Thread Robert Haas
On Thu, Mar 29, 2018 at 5:51 PM, Andres Freund wrote: >> > 2018-03-06 13:20:24.391 GMT [14869] ERROR: epoll_ctl() failed: Bad file >> > descriptor >> >> I can confirm this bug exists in single-user mode. > > I'm not sure we need to do anything about this, personally. This seems > like a fairly ra

Re: cannot drop replication slot if server is running in single-user mode

2018-03-29 Thread Bruce Momjian
On Thu, Mar 29, 2018 at 06:09:28PM -0700, Andres Freund wrote: > On 2018-03-29 21:07:36 -0400, Bruce Momjian wrote: > > I think the question is whether this is exposing a bug or is expected > > behavior. > > It's unsurprising. Acquiring a slot uses a condition variable, which > uses latches to sl

Re: cannot drop replication slot if server is running in single-user mode

2018-03-29 Thread Andres Freund
On 2018-03-29 21:07:36 -0400, Bruce Momjian wrote: > I think the question is whether this is exposing a bug or is expected > behavior. It's unsurprising. Acquiring a slot uses a condition variable, which uses latches to sleep. Latches don't work in single user mode. Boom. Greetings, Andres Freu

Re: cannot drop replication slot if server is running in single-user mode

2018-03-29 Thread Bruce Momjian
On Thu, Mar 29, 2018 at 02:51:24PM -0700, Andres Freund wrote: > On 2018-03-29 17:42:57 -0400, Bruce Momjian wrote: > > 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

Re: cannot drop replication slot if server is running in single-user mode

2018-03-29 Thread Andres Freund
On 2018-03-29 17:42:57 -0400, Bruce Momjian wrote: > 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_repl

Re: cannot drop replication slot if server is running in single-user mode

2018-03-29 Thread Bruce Momjian
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:  st