Re: [v9.2] Start new timeline for PITR - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [v9.2] Start new timeline for PITR
Date
Msg-id BANLkTimx0nO0+JhhjJWudzYvwoEKO=5fxg@mail.gmail.com
Whole thread Raw
In response to Re: [v9.2] Start new timeline for PITR  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [v9.2] Start new timeline for PITR
Re: [v9.2] Start new timeline for PITR
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump vs malloc
Next
From: Heikki Linnakangas
Date:
Subject: Re: [v9.2] Start new timeline for PITR