Re: Interrupt WAL recovery

Поиск
Список
Период
Сортировка
От Fabio Rueda Carrascosa
Тема Re: Interrupt WAL recovery
Дата
Msg-id CAA3M-fby1wRTE64=wBawi3ULtF0=t3MCF38BkesV1Uqxovf=5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Interrupt WAL recovery  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Ответы Re: Interrupt WAL recovery
Список pgsql-general
Дерево обсуждения
Can I stop the server and modify recovery.conf with this param and restart it again without problems?

Thanks a lot.


2013/5/22 Raghavendra <raghavendra.rao@enterprisedb.com>
On Wed, May 22, 2013 at 3:38 PM, Fabio Rueda Carrascosa <avances123@gmail.com> wrote:
hello , I'm restoring a 7 days ago full backup  + wal files. I have to recover more than 6k wal files and I have no time, I would accept to work with a ~ 3 days ago snapshot, can I stop the recovery process and start the server?, if yes, how?

My recovery.conf file only has this line :

restore_command = 'envdir /etc/wal-e.d/env /etc/wal-e.d/wal-e wal-fetch "%f" "%p"'

Thanks in advance.

You can control the recovery process with recovery_target_time parameter.  This parameter helps you to recover wals till to the acceptable time for you from the snapshot.


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