"Katsuhiko Okano" <okano(dot)katsuhiko(at)oss(dot)ntt(dot)co(dot)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