Recovery_target_time misinterpreted?

From: Klaus Ita <koki(dot)eml(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Recovery_target_time misinterpreted?
Date: 2013-07-31 06:59:40
Message-ID: CAK9oVJz6K5v2b89khaKZxzWvacdYYff=xCOtBm7H7cd5xmeEJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Albe Laurenz 2013-07-31 07:37:35 Re: Recovery_target_time misinterpreted?
Previous Message Michael Paquier 2013-07-31 05:36:15 Re: BUG #8346: Postgres BDR: Segmentation Fault observed during replication of binary object.

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-07-31 07:37:35 Re: Recovery_target_time misinterpreted?
Previous Message Tom Lane 2013-07-31 05:13:50 Re: Snapshot backups