Re: Turning slave into a master - PostgreSQL 9.2

[Patrick B <patrickbakerbr@xxxxxxxxx>]

2016-11-02 2:55 GMT+13:00 Scott Marlowe <scott.marlowe@xxxxxxxxx>:

On Mon, Oct 31, 2016 at 8:01 PM, Patrick B <patrickbakerbr@xxxxxxxxx> 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!