Postgres Pro
Downloads
Home   >   mailing lists

Re: Recovery_target_time misinterpreted? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Recovery_target_time misinterpreted?
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BF2378@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Recovery_target_time misinterpreted?  (Klaus Ita <koki.eml@gmail.com>)
Responses Re: Recovery_target_time misinterpreted?  (Klaus Ita <koki.eml@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Klaus Ita
Date:
Subject: Recovery_target_time misinterpreted?
Next
From: Marc Dahn
Date:
Subject: Type to to_char(d, 'J')?