Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1

From: melvin6925 <melvin6925(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1
Date: 2016-10-27 00:16:16
Message-ID: yfy6styb4c38dxpl84oshxwe.1477527155292@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com> Date: 10/26/16 19:50 (GMT-05:00) To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com> Cc: pgsql-general(at)postgresql(dot)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(dot)Xu(at)amdocs(dot)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(dot)klaver(at)aklaver(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Millman 2016-10-27 06:37:28 Re: Locking question
Previous Message Adrian Klaver 2016-10-26 23:50:08 Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1