Re: Turning slave into a master - PostgreSQL 9.2 - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Turning slave into a master - PostgreSQL 9.2
Date
Msg-id CA+bJJbymDPE7TNPDYUemVpeG0C-Ski0OfuCc5Zh=hHenSUAZyw@mail.gmail.com
Whole thread Raw
In response to Re: Turning slave into a master - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Hi:

On Tue, Nov 1, 2016 at 3:01 AM, Patrick B <patrickbakerbr@gmail.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.


pgsql-general by date:

Previous
From: 德哥
Date:
Subject: pgbench support dynamic identifier name
Next
From: Merlin Moncure
Date:
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other