Recovery_target_time misinterpreted? - Mailing list pgsql-general

From Klaus Ita
Subject Recovery_target_time misinterpreted?
Date
Msg-id CAK9oVJz6K5v2b89khaKZxzWvacdYYff=xCOtBm7H7cd5xmeEJQ@mail.gmail.com
Whole thread Raw
Responses Re: Recovery_target_time misinterpreted?
List pgsql-general
Hello PG Experts!

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'?

pg version:
xaxos_ch=> select version();
                                           version                                           
----------------------------------------------------------------------------------------------
 PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
(1 row)


somewhat irrelevant, as my question is more general?


thank you for your help!

klaus

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Snapshot backups
Next
From: Albe Laurenz
Date:
Subject: Re: Recovery_target_time misinterpreted?