On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz <laurenz.a...@wien.gv.at>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. > > Yours, > Laurenz Albe >
