Re: Restore postgres to specific time

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Kevin Grittner <kgrittn(at)mail(dot)com>
Cc: wd <wd(at)wdicc(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Restore postgres to specific time
Date: 2012-11-27 00:27:38
Message-ID: CAMkU=1zh=6zZ0gPA5qfDNcGfXHHVhgCufVAMjo_PuuhS_=V66g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner <kgrittn(at)mail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message classical_89 2012-11-27 01:23:25 Re: Correlation in pg_stats
Previous Message Francisco Figueiredo Jr. 2012-11-26 21:05:19 Re: Npgsql