Re: pg_ctl -m fast failing?

On Friday March 7 2003 11:56, Josh Berkus wrote:
> Tom,
>
> > No, I'd not expect the second stop to fail; and I can't reproduce any
> > such problem here.
>
> I've had it happen once.

I've seen this many times when a bug like that described below was in play
during shutdown. It's never been convenient to pin it down.

> > The known bug might cause the *first* stop to fail; it basically
> > triggers if you have a client that sits idle for a long time (while
> > other sessions are doing work) and still remains idle after the
> > shutdown command comes.
>
> So ... the workaround for 7.2.4 would be to have a server-side script
> hunt for idle connections after shutdown and kill -9 them?

There's a very small patch posted recently that fixes the problem, assuming
you can apply it.

Ed