Recovery.conf and PITR

Поиск
Список
Период
Сортировка
От ascot.moss@gmail.com
Тема Recovery.conf and PITR
Дата
Msg-id D4F75986-A768-4751-A2D9-D94BE093DCDD@gmail.com
обсуждение исходный текст
Ответ на Re: How to avoid Force Autovacuum  (Sergey Konoplev <gray.ru@gmail.com>)
Ответы Re: Recovery.conf and PITR
Re: Recovery.conf and PITR
Re: Recovery.conf and PITR
Список 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
shippedand saved in /var/pgsql/data/archive, the latest transaction txid of them is 75666.  I want to recover PG at a
pointof 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Jakob Egger
Дата:
Сообщение: How to contact Planet PostgreSQL
Следующее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Recovery.conf and PITR