Re: Restore postgres to specific time

[wd <wd@xxxxxxxxx>]

I can't connect to postgres at that time.

On Mon, Nov 26, 2012 at 4:33 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();

Yours,
Laurenz Albe