Horton

Re: [v9.2] Start new timeline for PITR

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Date: 2011-06-10T19:34:23Z
Lists: pgsql-hackers 
On Fri, Jun 10, 2011 at 2:53 PM, Josh Berkus <josh@agliodbs.com> wrote:
>> Let's imagine we're taking filesystem snapshots each day by whatever
>> means.  We're also archiving xlogs, but only have space for 48 hours'
>> worth.  Now we want to recover to 3 days ago, but there are no WALs
>> from that time, so we do a crash recovery from the filesystem
>> snapshot.  Doing continuous archiving from this conflicts with the
>> existing WALs, which we solve by creating a new timeline.
>
> How is this different from just changing the recovery_command?

*scratches head*

How is it the same?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company