Re: server won't shutdown

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