| 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: | Whole Thread | Raw Message | 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 |