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 <[email protected]> Date: 10/26/16 19:50 (GMT-05:00) To: Michael Paquier <[email protected]>, Joanna Xu <[email protected]> Cc: [email protected] 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 <[email protected]> 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 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
