Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID' - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'
Date
Msg-id 16854.1182439436@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'  ("Katsuhiko Okano" <okano.katsuhiko@oss.ntt.co.jp>)
List pgsql-bugs
Tree view 
"Katsuhiko Okano" <okano.katsuhiko@oss.ntt.co.jp> writes:
> Transaction ID can be specified when recovering using a PITR feature.
> For example, in recovery.conf,
> --------
> recovery_target_xid = '1100842'
> --------

The documentation already points out that this feature is currently
useless due to the lack of any tools for determining a suitable target
XID.  Presumably such a tool would help you dig through the WAL log
to see which transactions did what.  I'm not very concerned about the
set of possible target XIDs not being complete.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Katsuhiko Okano"
Date:
Subject: BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'
Next
From: "Jasen Betts"
Date:
Subject: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can