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

2016-10-28 Thread Melvin Davidson
al-owner@po > stgresql.org] *On Behalf Of *Melvin Davidson > *Sent:* Thursday, October 27, 2016 11:04 AM > *To:* Scott Mead > *Cc:* pgsql-general@postgresql.org > *Subject:* Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - > Postgres9.1 > > > > > >

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

2016-10-28 Thread Joanna Xu
l Message- > From: Adrian Klaver > [mailto:adrian.kla...@aklaver.com<mailto:adrian.kla...@aklaver.com>] > Sent: Wednesday, October 26, 2016 7:50 PM > To: Michael Paquier > mailto:michael.paqu...@gmail.com>>; Joanna Xu > mailto:joanna...@amdocs.com>> > Cc

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

2016-10-27 Thread Melvin Davidson
g as you exercise care, you will be fine, it's just an > important point that I've seen haunt people in the past. > > Thanks, > > Joanna > > > > -Original Message----- > > From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > > Sent: Wednesday, Oc

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

2016-10-27 Thread Scott Mead
7:50 PM > To: Michael Paquier ; Joanna Xu > > 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 wrote

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

2016-10-27 Thread Joanna Xu
om: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, October 26, 2016 7:50 PM To: Michael Paquier ; Joanna Xu 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: > O

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

2016-10-27 Thread Joanna Xu
Joanna Xu Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1 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 s

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

2016-10-26 Thread melvin6925
na Xu 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 wrote: >> I’ve been looking for a procedure (step by step) on how

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

2016-10-26 Thread Adrian Klaver
On 10/26/2016 04:43 PM, Michael Paquier wrote: On Wed, Oct 26, 2016 at 11:18 PM, Joanna Xu 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 server

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

2016-10-26 Thread Michael Paquier
On Wed, Oct 26, 2016 at 11:18 PM, Joanna Xu 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

[GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1

2016-10-26 Thread Joanna Xu
Hello, 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. Can someone please shed some light on how to implement this? Here's the assumption / expectation : 1. The rep