Re: In 8.2, shutdown wrongly caused automatic restart

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: In 8.2, shutdown wrongly caused automatic restart
Date: 2010-08-04 16:37:23
Message-ID: 20968.1280939843@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
> 6. ... the bgwriter had already ended even though there was a backend in
> progress. Postmaster regarded this situation as abnormal and caused the
> recovery.

> In 8.3 or later, since postmaster doesn't regard that situation as abnormal
> and just waits for all backends to exit again, the problem doesn't happen.
> I think that this is a bug in 8.2 and should be fixed in the same way as 8.3
> does. Thought?

My recollection is that that change was associated with some pretty
significant revisions to the postmaster state machine. I'm concerned
about the risks involved in back-patching that. This seems to be a
corner case with pretty minimal consequences anyway, so I'm inclined
to leave 8.2 alone.

Now, if I'm wrong about that and you can produce a simple and obviously
correct patch for 8.2, go ahead.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-08-04 16:40:09 Re: string_agg delimiter having no effect with order by
Previous Message Tom Lane 2010-08-04 15:29:39 Re: string_agg delimiter having no effect with order by