Re: PITR - recovery to a particular transaction - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: PITR - recovery to a particular transaction
Date
Msg-id 1091646928.58593.122.camel@jester
Whole thread Raw
In response to Re: PITR - recovery to a particular transaction  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: PITR - recovery to a particular transaction  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> You seem to be suggesting that using the id is less useful than the
> time, but surely it's going to be easier to say "this disaster happened
> in transaction 123 so lets do a PITR up to 122" than to say "this

Transaction IDs are assigned at transaction start but what you really
want is some indicator of when the commit occurred.

Transaction 123 may have committed while 122 was still running.




pgsql-hackers by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: PITR - recovery to a particular transaction
Next
From: Tom Lane
Date:
Subject: Re: 7.5 backend crash