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

From Jeff Janes
Subject Re: Restore postgres to specific time
Date
Msg-id CAMkU=1zh=6zZ0gPA5qfDNcGfXHHVhgCufVAMjo_PuuhS_=V66g@mail.gmail.com
Whole thread Raw
In response to Re: Restore postgres to specific time  ("Kevin Grittner" <kgrittn@mail.com>)
Responses Re: Restore postgres to specific time
List pgsql-general
On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner <kgrittn@mail.com> wrote:
> Jeff Janes wrote:
>
>> FATAL: requested recovery stop point is before consistent recovery point
>>
>> I don't understand why are you not getting this message.
>
> Is it before the point where pg_stop_backup() was run?

It turns out that the I had requested a time before even
pg_start_backup was run.

If I pick a time between start and stop, then I see the original
poster's symptoms.  The database does not start, but gives no notice
of the problem.


Cheers,

Jeff


pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: Npgsql
Next
From: wd
Date:
Subject: Re: Restore postgres to specific time