Re: Interrupt WAL recovery

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: Interrupt WAL recovery
Дата
Msg-id CA+h6AhgUEgiFbmXrt1ZOWxGkDPWXGFVXRYh=xp_=z2uPZLmg8g@mail.gmail.com
обсуждение исходный текст
Ответ на Interrupt WAL recovery  (Fabio Rueda Carrascosa <avances123@gmail.com>)
Ответы Re: Interrupt WAL recovery  (Fabio Rueda Carrascosa <avances123@gmail.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Fabio Rueda Carrascosa
Дата:
Сообщение: Interrupt WAL recovery
Следующее
От: Fabio Rueda Carrascosa
Дата:
Сообщение: Re: Interrupt WAL recovery