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+h6AhgUEgiFbmXrt1ZOWxGkDPWXGFVXRYh=xp_=z2uPZLmg8g@mail.gmail.com
Whole thread Raw
In response to Interrupt WAL recovery  (Fabio Rueda Carrascosa <avances123@gmail.com>)
Responses Re: Interrupt WAL recovery  (Fabio Rueda Carrascosa <avances123@gmail.com>)
List pgsql-general
Tree view
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: Interrupt WAL recovery
Next
From: Fabio Rueda Carrascosa
Date:
Subject: Re: Interrupt WAL recovery