Re: Shutting down a warm standby database in 8.2beta3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Shutting down a warm standby database in 8.2beta3
Date
Msg-id 25440.1164311247@sss.pgh.pa.us
Whole thread Raw
In response to Re: Shutting down a warm standby database in 8.2beta3  (Stephen Harris <lists@spuddy.org>)
Responses Re: Shutting down a warm standby database in 8.2beta3  (Stephen Harris <lists@spuddy.org>)
Re: Shutting down a warm standby database in 8.2beta3  (Stephen Harris <lists@spuddy.org>)
List pgsql-hackers
Stephen Harris <lists@spuddy.org> writes:
> OK, I just did the same tests on the CVS tree, rather than beta3 and
> I see different results.  This time recovery aborts with a PANIC.

Yeah, that's expected since the whole recovery process is a critical
section.  We could change that but it's cosmetic.

> Restarting the database appears to go back to asking for archive log 5
> again.

It would back up to whereever the last recovery checkpoint was.  I think
we've got it hardwired at one recovery checkpoint per 100 source
checkpoints ... maybe that's too far apart.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephen Harris
Date:
Subject: Re: Shutting down a warm standby database in 8.2beta3
Next
From: Dave Page
Date:
Subject: Re: 8.2 open items list