Re: Error restoring from a base backup taken from standby

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Error restoring from a base backup taken from standby
Date: 2012-12-18 09:35:47
Message-ID: 50D038F3.1090604@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 18.12.2012 11:30, Simon Riggs wrote:
> On 18 December 2012 09:18, Heikki Linnakangas<hlinnakangas(at)vmware(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-12-18 11:09:28 Re: pg_basebackup from cascading standby after timeline switch
Previous Message Dimitri Fontaine 2012-12-18 09:33:12 Re: Parser Cruft in gram.y