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
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. |
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 |