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

From Jeff Janes
Subject Re: Restore postgres to specific time
Date
Msg-id CAMkU=1wzH0zREuzBB5FNj5zuUsa-x=ue5BTOb30HX_hnUzEPDA@mail.gmail.com
Whole thread Raw
In response to Re: Restore postgres to specific time  (wd <wd@wdicc.com>)
Responses Re: Restore postgres to specific time  (wd <wd@wdicc.com>)
List pgsql-general
On Sat, Nov 24, 2012 at 6:00 AM, wd <wd@wdicc.com> wrote:
> Yes,  you are right, after set the two command, the recovery will stop at
> that time.
>
> But there is an other question, how to make this recovered Postgres can be
> read and write? According to the manual, Postgres should be rename
> recovery.conf to recovery.done, but it didn't.

This is after you removed "standby_mode=on"?

It should happen automatically.

What entries are you getting in the log file?

Cheers,

Jeff


pgsql-general by date:

Previous
From: Christian Hammers
Date:
Subject: How and for what to use SP-GIST?
Next
From: "Kevin Grittner"
Date:
Subject: Re: High SYS CPU - need advise