Postgres Pro
Downloads
Home   >   mailing lists

Re: Interrupt WAL recovery - Mailing list pgsql-general

From Fabio Rueda Carrascosa
Subject Re: Interrupt WAL recovery
Date
Msg-id CAA3M-fby1wRTE64=wBawi3ULtF0=t3MCF38BkesV1Uqxovf=5A@mail.gmail.com
Whole thread Raw
In response to Re: Interrupt WAL recovery  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: Interrupt WAL recovery
List pgsql-general
Tree view
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 by date:

Previous
From: Raghavendra
Date:
Subject: Re: Interrupt WAL recovery
Next
From: Raghavendra
Date:
Subject: Re: Interrupt WAL recovery