Postgres Pro
Downloads
Home   >   mailing lists

Re: Recovery.conf and PITR - Mailing list pgsql-general

From wd
Subject Re: Recovery.conf and PITR
Date
Msg-id CABexzmhLmBucKRr2NT4v7S8p1K0g_bZBf3436jmmpX+zwqHs1Q@mail.gmail.com
Whole thread Raw
In response to Recovery.conf and PITR  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Responses Re: Recovery.conf and PITR  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-general
Tree view 
Try add these settings, 

pause_at_recovery_target=true
recovery_target_inclusive=false


On Fri, Aug 9, 2013 at 4:09 PM, ascot.moss@gmail.com <ascot.moss@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

pgsql-general by date:

Previous
From: Don Parris
Date:
Subject: Re: How To Install Extension Via Script File?
Next
From: Luca Ferrari
Date:
Subject: Re: Recovery.conf and PITR