Re: Error restoring from a base backup taken from standby

Heikki Linnakangas <hlinnakangas@vmware.com>

From: Heikki Linnakangas <hlinnakangas@vmware.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-12-18T09:35:47Z
Lists: pgsql-hackers
On 18.12.2012 11:30, Simon Riggs wrote:
> On 18 December 2012 09:18, Heikki Linnakangas<hlinnakangas@vmware.com>  wrote:
>
>> That seems correct to me. The backup is considered valid after reaching
>> 0/1764F48, which is where the checkpoint record ends. minRecoveryPoint is
>> set to the same. What do you think it should be set to?
>
> I already said?

In this situation, there are no more WAL records in the standby the 
backup was taken from, after the checkpoint record. Using receivedUpto 
would yield the same value, and you'd still have the same problem.

- Heikki