Postgres Pro
Downloads
Home   >   mailing lists

Re: Error restoring from a base backup taken from standby - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Error restoring from a base backup taken from standby
Date
Msg-id 50D038F3.1090604@vmware.com
Whole thread Raw
In response to Re: Error restoring from a base backup taken from standby  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Parser Cruft in gram.y
Next
From: Simon Riggs
Date:
Subject: Re: pg_basebackup from cascading standby after timeline switch