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

From Tom Lane
Subject Re: PITR - recovery to a particular transaction
Date
Msg-id 3751.1091643364@sss.pgh.pa.us
Whole thread Raw
In response to PITR - recovery to a particular transaction  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: PITR - recovery to a particular transaction  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-hackers
Oliver Elphick <olly@lfix.co.uk> writes:
> How about adding a logging option to put the transaction id on the log
> for every statement that modifies the database?  Would that be a small
> enough change to be allowed into 8.0?

I think we could get away with adding transaction ID as one of the
available %-items in log_line_prefix.  I'm not sure how useful this
really is though --- timestamps are probably more useful overall to
have in your log.  The direction I was expecting we'd head in is to
provide WAL logfile examination tools.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: pgxs: build infrastructure for extensions v4
Next
From: Tom Lane
Date:
Subject: DROP TABLESPACE causes panic during recovery