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