Re: Recovery.conf and PITR

Try add these settings,

pause_at_recovery_target=true
recovery_target_inclusive=false

On Fri, Aug 9, 2013 at 4:09 PM, ascot(dot)moss(at)gmail(dot)com
<ascot(dot)moss(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>