Re: pg_ctl -m fast failing?

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

> 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?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Eric B.Ridge
Дата:
Сообщение: division by zero
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: replicating DDL statements