Re: Shutting down a warm standby database in 8.2beta3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Harris <lists(at)spuddy(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Shutting down a warm standby database in 8.2beta3
Date: 2006-11-23 19:47:27
Message-ID: 25440.1164311247@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Stephen Harris <lists(at)spuddy(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-11-23 21:41:35 pg_dump
Previous Message Stephen Harris 2006-11-23 19:38:27 Re: Shutting down a warm standby database in 8.2beta3

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2006-11-23 19:52:38 Re: 8.2 open items list
Previous Message Stephen Harris 2006-11-23 19:38:27 Re: Shutting down a warm standby database in 8.2beta3