Re: Recovery_target_time misinterpreted?

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Klaus Ita *EXTERN*" <koki(dot)eml(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recovery_target_time misinterpreted?
Date: 2013-07-31 07:37:35
Message-ID: A737B7A37273E048B164557ADEF4A58B17BF2378@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Klaus Ita wrote:
> I have restored a Database Cluster with a recovery_target_time set to
>
> recovery_target_time = '2013-07-27 21:20:17.127664+00'
> recovery_target_inclusive = false
>
>
>
> now it seems the restore rather restored to some point in time (rather the 18th than the 27th). Is
> there an explanation for this huge gap? Is that the last 'consistent state'?

Maybe the log entries created during restore can answer the question.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message G.Bakalarski 2013-07-31 08:24:40 Re: BUG #8318: memory leak during CREATE TEMPORARY TABLE
Previous Message Klaus Ita 2013-07-31 06:59:40 Recovery_target_time misinterpreted?

Browse pgsql-general by date

  From Date Subject
Next Message Marc Dahn 2013-07-31 09:09:22 Type to to_char(d, 'J')?
Previous Message Klaus Ita 2013-07-31 06:59:40 Recovery_target_time misinterpreted?