Re: Recovery.conf and PITR

Поиск
Список
Период
Сортировка
От wd
Тема Re: Recovery.conf and PITR
Дата
Msg-id CABexzmhLmBucKRr2NT4v7S8p1K0g_bZBf3436jmmpX+zwqHs1Q@mail.gmail.com
обсуждение исходный текст
Ответ на Recovery.conf and PITR  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Ответы Re: Recovery.conf and PITR  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Don Parris
Дата:
Сообщение: Re: How To Install Extension Via Script File?
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: Recovery.conf and PITR