Re: Interrupt WAL recovery

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(dot)rao(at)enterprisedb(dot)com>

> On Wed, May 22, 2013 at 3:38 PM, Fabio Rueda Carrascosa <
> avances123(at)gmail(dot)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.
>
> http://www.postgresql.org/docs/9.2/static/recovery-target-settings.html
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>