Re: Restore postgres to specific time

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "wd *EXTERN*" <wd(at)wdicc(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restore postgres to specific time
Date: 2012-11-26 08:33:06
Message-ID: D960CB61B694CF459DCFB4B0128514C208C0BCF3@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vlad K. 2012-11-26 09:35:39 Copy rows, remember old and new pkey
Previous Message Magnus Hagander 2012-11-26 08:32:13 Re: Regarding getting source from 9.2.0beta1 and 9.2beta1.