Re: pg_ctl -m fast failing?

Поиск
Список
Период
Сортировка
От Ed L.
Тема Re: pg_ctl -m fast failing?
Дата
Msg-id 200303071319.08332.pgsql@bluepolka.net
обсуждение исходный текст
Ответ на Re: pg_ctl -m fast failing?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Pam Wampler
Дата:
Сообщение: Re: division by zero
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: division by zero