We need to keep the data as it is so remving data fold is not feasible. If I run "pg_ctl promote" on the slave to make it fail over, this will break the replication and then clean up the configuration related to replication. Any feedback?
Thanks, Joanna -----Original Message----- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, October 26, 2016 7:50 PM To: Michael Paquier <michael.paqu...@gmail.com>; Joanna Xu <joanna...@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...@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.kla...@aklaver.com This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at http://www.amdocs.com/email_disclaimer.asp -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
