Re: [PATCHES] Revised patch for fixing archiver shutdown behavior

2008-01-11 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes:
> If we do a shutdown immediate on the postmaster *after* the bgwriter has
> written a shutdown checkpoint, do we have any record that there was a
> panic stop? Do we enter recovery in that case? I think the answers are
> yes and no, but just checking.

Yeah, the postmaster would complain at exit, but the pg_control state
is already SHUTDOWN at that point.  There'd be a log entry showing
abnormal archiver exit if the panic had had any actual effect on it.

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [PATCHES] Revised patch for fixing archiver shutdown behavior

2008-01-11 Thread Simon Riggs
On Thu, 2008-01-10 at 14:08 -0500, Tom Lane wrote:
> I wrote:
> > I'll respin my patch this way...
> 
> Third time's the charm?

If we do a shutdown immediate on the postmaster *after* the bgwriter has
written a shutdown checkpoint, do we have any record that there was a
panic stop? Do we enter recovery in that case? I think the answers are
yes and no, but just checking.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


---(end of broadcast)---
TIP 6: explain analyze is your friend