Re: Turning slave into a master - PostgreSQL 9.2

From: Scott Marlowe <scott(dot)marlowe(at)gmail(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 13:55:03
Message-ID: CAOR=d=0vJfeQt6VyOJgBvoSRSa9G4AOf5yyFkT7MWT8mj5_3fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 31, 2016 at 8:01 PM, 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

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François Battail 2016-11-01 14:43:41 Statistics on index usage
Previous Message Merlin Moncure 2016-11-01 13:13:39 Re: How to hint 2 coulms IS NOT DISTINCT FROM each other