you can use pg_xlog_replay_pause(),pg_xlog_replay_resume() to control the
wal replay.
ref doc:http://www.postgresql.org/docs/9.1/static/functions-admin.html
2013/5/22 Raghavendra
>
> On Wed, May 22, 2013 at 4:15 PM, Raghavendra <
> raghavendra@enterprisedb.com> wrote:
>
>> On Wed, May 22, 2
On Wed, May 22, 2013 at 4:15 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Wed, May 22, 2013 at 3:53 PM, Fabio Rueda Carrascosa <
> avances...@gmail.com> wrote:
>
>> Can I stop the server and modify recovery.conf with this param and
>> restart it again without problems?
>>
>>
> I
On Wed, May 22, 2013 at 3:53 PM, Fabio Rueda Carrascosa <
avances...@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 wit
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
> 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.
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 proces
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_com
