Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore postgres to specific time - Mailing list pgsql-general

From wd
Subject Re: Restore postgres to specific time
Date
Msg-id CABexzmjze+Jzd7gNVPMeLzF=bX1yRh0HHGv1-odps8tOQMG37Q@mail.gmail.com
Whole thread Raw
In response to Re: Restore postgres to specific time  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: Restore postgres to specific time
List pgsql-general
Tree view
I can't connect to postgres at that time.


On Mon, Nov 26, 2012 at 4:33 PM, Albe Laurenz <laurenz.albe@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();

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Issue with pg_toast tables
Next
From: "Albe Laurenz"
Date:
Subject: Re: Restore postgres to specific time