On 10.06.2011 22:34, Robert Haas wrote:
On Fri, Jun 10, 2011 at 2:53 PM, Josh Berkus<j...@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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to