Postgres Pro
Downloads
Home   >   mailing lists

Re: Interrupt WAL recovery - Mailing list pgsql-general

From Raghavendra
Subject Re: Interrupt WAL recovery
Date
Msg-id CA+h6AhhePVGC-s7E-TECvXugPzH7UsLQEwFWfyBZ+sm3P9ChFA@mail.gmail.com
Whole thread Raw
In response to Re: Interrupt WAL recovery  (Fabio Rueda Carrascosa <avances123@gmail.com>)
Responses Re: Interrupt WAL recovery
List pgsql-general
Tree view
On Wed, May 22, 2013 at 3:53 PM, Fabio Rueda Carrascosa <avances123@gmail.com> wrote:
Can I stop the server and modify recovery.conf with this param and restart it again without problems?


It should work. (Sorry I never tried this, like stopping in middle of the recovery and restarting with some changes. Sure there will be answer's here if someone has more insight on this scenario) 

Its good to include this parameter in recovery.conf at the recovery start time. 

-- Raghav


 

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 by date:

Previous
From: Fabio Rueda Carrascosa
Date:
Subject: Re: Interrupt WAL recovery
Next
From: Raghavendra
Date:
Subject: Re: Interrupt WAL recovery