Re: server won't shutdown

Поиск
Список
Период
Сортировка
От Ed L.
Тема Re: server won't shutdown
Дата
Msg-id 200302191811.33796.pgsql@bluepolka.net
обсуждение исходный текст
Ответ на Re: server won't shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Monday February 17 2003 8:06, Tom Lane wrote:
>
> Attached is the fix against 7.3 (or CVS tip).  The same bug exists
> in 7.2 and 7.1, and should be fixable by the same patch (possibly
> with some fuzz).
>
> You can demonstrate the problem by doing 'LISTEN foo' in one psql
> and then 'NOTIFY foo' in another, then attempting a fast shutdown
> --- the first psql's backend will ignore you until the psql session
> does something. The same path can be followed without LISTEN if the
> first psql is simply left idle while the second one does a bunch of
> catalog-updating work (a few cycles of VACUUM ANALYZE usually
> suffice).

I have verified this fixed the problem on 7.2.4 in the case of the
latter VACUUM ANALYZE example, and will test it also against 7.3.2
before too long.  Thanks again, Tom.

Ed


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

Предыдущее
От: radha.manohar@ndsu.nodak.edu
Дата:
Сообщение: Re: Concurrency control in postgresql
Следующее
От: "Yudha Setiawan"
Дата:
Сообщение: Re: How to avoid the Mutating Triggers ??