Re: [BUGS] In 8.2, shutdown wrongly caused automatic restart

2010-08-05 Thread Fujii Masao
On Thu, Aug 5, 2010 at 1:45 AM, Alvaro Herrera wrote: > Excerpts from Tom Lane's message of mié ago 04 12:37:23 -0400 2010: >> 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

Re: [BUGS] In 8.2, shutdown wrongly caused automatic restart

2010-08-04 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié ago 04 12:37:23 -0400 2010: > Fujii Masao 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 postm

Re: [BUGS] In 8.2, shutdown wrongly caused automatic restart

2010-08-04 Thread Tom Lane
Fujii Masao 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 backend

[BUGS] In 8.2, shutdown wrongly caused automatic restart

2010-08-04 Thread Fujii Masao
Hi, In my customer's system using v8.2.5, even though no process exited abnormally, the fast shutdown wrongly caused the automatic restart of a database. The server log is as follows: Jul 18 16:21:51 postgres[26624]: [1-1] LOG: received fast shutdown request Jul 18 16:21:51 postgres[26624]: [2