From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Turning slave into a master - PostgreSQL 9.2 |
Date: | 2016-11-01 10:23:04 |
Message-ID: | CA+bJJbymDPE7TNPDYUemVpeG0C-Ski0OfuCc5Zh=hHenSUAZyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
On Tue, Nov 1, 2016 at 3:01 AM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:
> If I change recovery.conf:
> recovery_target_time = '2016-10-30 02:24:40'
> I get error:
> FATAL: requested recovery stop point is before consistent recovery point
It looks clear. When you take a base backup from a running system some
recovery is needed to make it consistent. With the target time you can
limit how much is done. But there is a minimum. Think of it, if you
stated '1970-01-01' it would be clearly imposible, your date is
bigger, but still imposible, try raising it a bit.
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2016-11-01 13:13:39 | Re: How to hint 2 coulms IS NOT DISTINCT FROM each other |
Previous Message | 德哥 | 2016-11-01 09:46:29 | pgbench support dynamic identifier name |