Try add these settings, pause_at_recovery_target=true recovery_target_inclusive=false
On Fri, Aug 9, 2013 at 4:09 PM, 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'. > > postgres=# select txid_current(); > txid_current > -------------- > 75666 > (1 row) > > > Can you please advise? > > regards > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
