Re: pg_basebackup from cascading standby after timeline switch

Simon Riggs <simon@2ndquadrant.com>

From: Simon Riggs <simon@2ndQuadrant.com>
To: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-12-17T22:44:08Z
Lists: pgsql-hackers
On 17 December 2012 14:16, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:

> I'm not happy with the fact that we just ignore the problem in a backup
> taken from a standby, silently giving the user a backup that won't start up.

That's spooky. I just found a different issue with prmotion during
backup on your other thread.

> Why not include the timeline history file in the backup? That seems like a
> good idea regardless of this issue.

Yeh

> I also wonder if pg_basebackup should
> include *all* timeline history files in the backup, not just the latest one
> strictly required to restore.

Why? the timeline history file includes the previous timelines already.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services