The following bug has been logged online:
Bug reference: 3401
Logged by: Katsuhiko Okano
Email address: okano.katsuhiko@oss.ntt.co.jp
PostgreSQL version: Head(20070607)
Operating system: Fedora Core release 5 (Bordeaux)
Description: PITR does not work in the case of recovery_target_xid =
'SELECT_only_transaction_ID'
Details:
Transaction ID is wasted even if it is a transaction containing only
SELECT.
Transaction ID can be specified when recovering using a PITR feature.
For example, in recovery.conf,
--------
recovery_target_xid = '1100842'
--------
A PITR feature does not work in the case which specified transaction ID in
recovery_target_xid
corresponding to the transaction which contains only SELECT
It expects to stop in foward of target ID or in backward of target ID.
However, it does not stop while recovery done.
Recovery is done to the last and it becomes the newest.(target ID is
disregarded)
This operation is unexpected.I think that it should describe on a document.
