Re: server won't shutdown - Mailing list pgsql-admin

From Ed L.
Subject Re: server won't shutdown
Date
Msg-id 200302191811.33796.pgsql@bluepolka.net
Whole thread Raw
In response to Re: server won't shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: radha.manohar@ndsu.nodak.edu
Date:
Subject: Re: Concurrency control in postgresql
Next
From: "Yudha Setiawan"
Date:
Subject: Re: How to avoid the Mutating Triggers ??