Re: Restore postgres to specific time

On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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
>