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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: 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-26 23:43:16
Message-ID: CAB7nPqROFSMSAMh3AMd4UR9A0qBUH2QSE=5fPSrf3Y0GZ0qjqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-10-26 23:50:08 Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1
Previous Message Kevin Grittner 2016-10-26 22:18:13 Re: SERIALIZABLE and INSERTs with multiple VALUES