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

From Patrick B
Subject Re: Turning slave into a master - PostgreSQL 9.2
Date
Msg-id CAJNY3iuZbsUJM8tzwSA9Vr7uHaMMNJidffe_DaSYs0dpWMLO1Q@mail.gmail.com
Whole thread Raw
In response to Re: Turning slave into a master - PostgreSQL 9.2  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Turning slave into a master - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Re: Turning slave into a master - PostgreSQL 9.2  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general


2016-11-02 2:55 GMT+13:00 Scott Marlowe <scott.marlowe@gmail.com>:
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.


I did a pg_basebackup!

pgsql-general by date:

Previous
From: Joshua Kehn
Date:
Subject: Re: Validity of using the test_decoding plugin for production?
Next
From: Michael Paquier
Date:
Subject: Re: Validity of using the test_decoding plugin for production?