On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
wd wrote:
>>> Logs are something like this:
>>>
>>> [ 2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
>>> [ 2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT:
Execute pg_xlog_replay_resume() to continue.
>>
>> Well, try
>>
>> SELECT pg_xlog_replay_resume();
>
> I can't connect to postgres at that time.Duh.
Then the trick is not to pause at all.
Make sure that pause_at_recovery_target is not set in
recovery.conf.
Stop the recovering server, then start it again.
That should do the trick.
I've tried set pause_at_recovery_target to true, it's not work. and also tried comment out this setting it's the same.
Restart have no effect, the recovery.conf is always there, I think it's should be rename to recovery.done if it's work.
Restart have no effect, the recovery.conf is always there, I think it's should be rename to recovery.done if it's work.
Yours,
Laurenz Albe
