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

From Scott Marlowe
Subject Re: Turning slave into a master - PostgreSQL 9.2
Date
Msg-id CAOR=d=0vJfeQt6VyOJgBvoSRSa9G4AOf5yyFkT7MWT8mj5_3fw@mail.gmail.com
Whole thread Raw
In response to Re: Turning slave into a master - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Turning slave into a master - PostgreSQL 9.2
List pgsql-general
On Mon, Oct 31, 2016 at 8:01 PM, 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

You can try using pg_basebackup to get the replica setup. In 9.2 you
gotta make your own recovery.conf, but you already know how to do
that. Way easier than trying to rsync by hand etc.


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Next
From: François Battail
Date:
Subject: Statistics on index usage