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. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
