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 по дате отправления: