On Sun, Feb 23, 2014 at 7:20 AM, Murthy Nunna <mnunna@xxxxxxxx> wrote:
While I understand your explanation, I feel I am still missing something. IMHO, when I say pause using “pause” setting, no matter what, I expect the recovery to wait for manual intervention.
Have you explored using "pg_xlog_replay_pause()" and "pg_xlog_replay_resume()"? See http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL-TABLE