It's simple
just look in recovery. conf on slave and put stated trigger. then slave becomes stand alone.
Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone
-------- Original message --------
From: Adrian Klaver <adrian.klaver@aklaver.com>
Date: 10/26/16 19:50 (GMT-05:00)
To: Michael Paquier <michael.paquier@gmail.com>, Joanna Xu <Joanna.Xu@amdocs.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1
On 10/26/2016 04:43 PM, Michael Paquier wrote:
> On Wed, Oct 26, 2016 at 11:18 PM, Joanna Xu <Joanna.Xu@amdocs.com> wrote:
>> I’ve been looking for a procedure (step by step) on how to remove Standby
>> (SLAVE) from Primary (MASTER) for Postgres9.1 in google and the archived
>> postings, but no luck.
>
> Standby and master servers are two separate Postgres instances. So if
> you would like to remove a standby from a cluster. You just need to
> basically stop it, then remove its data folder. And you are done.
> There is no complicated science here.
Not sure that is what OP wants. From the original post:
" ...
2. After the standby is removed from the primary, both of nodes
are in standalone configuration. "
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
