Re: [v9.2] Start new timeline for PITR
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org
Date: 2011-06-10T19:38:37Z
Lists: pgsql-hackers
On 10.06.2011 22:34, Robert Haas wrote: > 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? Creating a dummy recovery.conf with bogus recovery_command would do the trick. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com