Re: Shutting down a warm standby database in

Stephen Harris <lists(at)spuddy(dot)org> writes:
> On Thu, Nov 30, 2006 at 03:59:15PM -0500, Tom Lane wrote:
>> Actually I was misremembering that: the frequency of recovery
>> checkpoints is time-based, and for a slave that's in sync with its
>> master, they should occur about as often as checkpoints on the master.
>> So the amount of log to be replayed should be comparable to what the
>> master would have to replay if it crashed.

> As a test, I started a recover, recovered 11 archive logs
> (000000010000000000000035 to 00000001000000000000003F), some may have had
> activity; I not sure. I then waited 10 minutes after the last log file
> had been replayed. Then I did a fast shutdown. Starting the standby
> database again required it going back to 000000010000000000000035 again.

That case is not what I described --- you weren't tracking a live master
that's generating checkpoints.

regards, tom lane