Horton

Re: PITR Phase 2 - Design Planning

Bruno Wolff III <bruno@wolff.to>

View thread
From: Bruno Wolff III <bruno@wolff.to>
To: Richard Huxton <dev@archonet.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Simon Riggs <simon@2ndquadrant.com>, Alvaro Herrera <alvherre@dcc.uchile.cl>, pgsql-hackers@postgresql.org
Date: 2004-04-27T17:43:25Z
Lists: pgsql-hackers 
On Tue, Apr 27, 2004 at 10:38:45 +0100,
  Richard Huxton <dev@archonet.com> wrote:
> 
> Speaking as a DBA, what I usually want to do is restore to "immediately before 
> I started the payroll calculation". An actual wall-clock time is mostly 
> irrelevant to me.

For long running transactions where you want to recover as much as possible,
one might also want to recover up until just before a specific transaction
committed (as opposed to started).