On Fri, Aug 9, 2013 at 10:09 AM, ascot.m...@gmail.com <ascot.m...@gmail.com> wrote: > Hi, > > I am trying PITR in a test machine (same PG version 9.2.4 same O/S Ubuntu > 12.04 64 bit). All archived WAL files are shipped and saved in > /var/pgsql/data/archive, the latest transaction txid of them is 75666. I > want to recover PG at a point of time that if XIDs are equal or smaller than > '75634' so I have the following recovery.conf (only two lines): > > restore_command = 'cp /var/pgsql/data/archive/%f %p' > recovery_target_xid = '75634' > > > After the restart of PG, the recovery.conf is processed and it is renamed to > recovery.done. However it restored all (75666) instead of '75634'.
Any chance the 75666 committed before the one you specified as target? >From the docs >(http://www.postgresql.org/docs/9.1/static/recovery-target-settings.html): The transactions that will be recovered are those that committed before (and optionally including) the specified one. Luca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
