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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [v9.2] Start new timeline for PITR
Date: 2011-06-10 18:57:38
Message-ID: 4DF26922.4060109@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David,

> 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?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-06-10 19:07:00 Re: pg_dump vs malloc
Previous Message Tom Lane 2011-06-10 18:57:21 Re: [BUG] Denormal float values break backup/restore