Recovery.conf and PITR

From: "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Cc: ascot(dot)moss(at)gmail(dot)com
Subject: Recovery.conf and PITR
Date: 2013-08-09 08:09:49
Message-ID: D4F75986-A768-4751-A2D9-D94BE093DCDD@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gabriele Bartolini 2013-08-09 08:41:03 Re: Recovery.conf and PITR
Previous Message Sergey Konoplev 2013-08-09 06:24:52 Re: How to avoid Force Autovacuum

Browse pgsql-general by date

  From Date Subject
Next Message Gabriele Bartolini 2013-08-09 08:41:03 Re: Recovery.conf and PITR
Previous Message Jakob Egger 2013-08-09 08:04:23 How to contact Planet PostgreSQL