Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 369A91D7D621 for ; Fri, 20 Apr 2012 03:01:56 -0300 (ADT) Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SL6uo-0007vk-MA for pgsql-admin@postgresql.org; Fri, 20 Apr 2012 06:01:55 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1SL6uc-0007mX-96 for pgsql-admin@postgresql.org; Thu, 19 Apr 2012 23:01:42 -0700 Date: Thu, 19 Apr 2012 23:01:42 -0700 (PDT) From: videanuadrian To: pgsql-admin@postgresql.org Message-ID: <1334901683.17673.YahooMailClassic@web160204.mail.bf1.yahoo.com> In-Reply-To: <1ef8f6b1.e64b.136cdc22de2.Coremail.jenopob@126.com> References: <1309678517759-4546630.post@n5.nabble.com> <1334641370515-5645680.post@n5.nabble.com> <348c54fa.6443.136c8731742.Coremail.jenopob@126.com> <1334832426.97159.YahooMailClassic@web160205.mail.bf1.yahoo.com> <1ef8f6b1.e64b.136cdc22de2.Coremail.jenopob@126.com> Subject: Re: How to auto swtich the roles of primary and standby MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_55425_33535816.1334901702276" X-Pg-Spam-Score: 0.9 (/) X-Archive-Number: 201204/111 X-Sequence-Number: 39447 ------=_Part_55425_33535816.1334901702276 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable hi, i tried the exact setup that you described here, but unfortunately i ha= d to restart the new master(former slave)=C2=A0 in order to get the new set= tings and this will conduct to a downtime and service interruption. anyway thanks for sharing your experience. Adrian Videanu --- On Fri, 4/20/12, jenopob [via PostgreSQL] wrote: From: jenopob [via PostgreSQL] Subject: Re:Re:Re: How to auto swtich the roles of primary and standby To: "videanuadrian" Date: Friday, April 20, 2012, 6:18 AM =09hi thereI prepared two postgresql.conf on the servers ,use shell script = to change which config should use .there are some config fields not the sma= e between the two config files .At 2012-04-19 18:47:26,"videanuadrian=C2=A0= [via=C2=A0PostgreSQL]"=C2=A0<[hidden email]> wrote: so, just to make sure that i understand:=20 after the master failed, the slave become the new master, the you have chan= ged postgresql.conf from master to slave and viceversa and restarted the ol= d master as slave ? --- On Thu, 4/19/12, jenopob [via PostgreSQL] <[hidden email]> wrote: From: jenopob [via PostgreSQL] <[hidden email]> Subject: Re:Re: How to auto swtich the roles of primary and standby To: "videanuadrian" <[hidden email]> Date: Thursday, April 19, 2012, 5:34 AM =09hi=C2=A0we did a new shell script named recovery_config_chage.sh at stan= dby server.the script I wanted to change the fail down postgres master conf= ig ,let it start as standby serverand build the communication with the form= er standby now is master server,then started it by remotestart.sh=C2=A0=C2= =A0the above hopes to help you something=C2=A0At 2012-04-17 13:42:50,"videa= nuadrian=C2=A0[via=C2=A0PostgreSQL]"=C2=A0<[hidden email]> wrote: =20 =09Hi there,=20 i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu =09 =09 =09 =09 =09 =09=09If you reply to this email, your message will be added to the discuss= ion below: =09=09http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-= of-primary-and-standby-tp4546630p5645680.html =09 =09 =09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09 =09 =09 =09 =09 =09 =09=09If you reply to this email, your message will be added to the discuss= ion below: =09=09http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-= of-primary-and-standby-tp4546630p5650704.html =09 =09 =09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09 =09 =09 =09 =09 =09 =09=09If you reply to this email, your message will be added to the discuss= ion below: =09=09http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-= of-primary-and-standby-tp4546630p5651436.html =09 =09 =09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09 =09 =09 =09 =09 =09 =09=09If you reply to this email, your message will be added to the discuss= ion below: =09=09http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-= of-primary-and-standby-tp4546630p5653287.html =09 =09 =09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09 -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-t= o-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5653410.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ------=_Part_55425_33535816.1334901702276 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable
hi, i tried the exact setup that you describe= d here, but unfortunately i had to restart the new master(former slave)&nbs= p; in order to get the new settings and this will conduct to a downtime and= service interruption.
anyway thanks for sharing your experience.
Adrian Videanu

--- On Fri, 4/20/12, jenopob [via PostgreSQL] = <[hidden email]>= wrote:

From: jenopob [via PostgreSQL] <= [hidden email]>
Subject:= Re:Re:Re: How to auto swtich the roles of primary and standby
To: "vide= anuadrian" <[hidden email]= >
Date: Friday, April 20, 2012, 6:18 AM

=09
hi there
I prepared two postgresql.conf o= n the servers ,use shell script to change which config should use .
there are some config fields not the smae between the two config files .=
At 2012-04-19 18:47:26,"videanuadrian [via PostgreSQL]" &= lt;[hidden email]= > wrote:
so, just to make sure that i understand:
after the = master failed, the slave become the new master, the you have changed postgr= esql.conf from master to slave and viceversa and restarted the old master a= s slave ?

--- On Thu, 4/19/12, jenopob [via PostgreSQL] <[hidden email]> wrote:

From: jenopob [via= PostgreSQL] <[hid= den email]>
Subject: Re:Re: How to auto swtich the roles of prima= ry and standby
To: "videanuadrian" <[hidden email]>
Date: Thursday, April 19, 20= 12, 5:34 AM

=09
hi
 
we did a new shell sc= ript named recovery_config_chage.sh at standby server.
the script= I wanted to change the fail down postgres master config ,let it start as s= tandby server
and build the communication with the former standby= now is master server,then started it by remotestart.sh 
&nb= sp;
the above hopes to help you something
 
<= div id=3D"yiv1577978645divNeteaseMailCard">
At 2012-04-17 1= 3:42:50,"videanuadrian [via PostgreSQL]" <[hidden email]> wrote:
=09Hi there,=20
i have the exact same problem. Did you find a solution for this ?
thanks,
Adrian Videanu =09 =09
=09
=09
=09
=09=09
If you reply to this email, your me= ssage will be added to the discussion below:
=09=09http://postgresql.1045698.n5.nabble.com= /How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5645680.html= =09
=09
=09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09


=09 =09
=09
=09
=09
=09=09
If you reply to this email, your me= ssage will be added to the discussion below:
=09=09http://postgresql.1045698.n5.nabble.com= /How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5650704.html= =09
=09
=09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09
=09 =09
=09
=09
=09
=09=09
If you reply to this email, your me= ssage will be added to the discussion below:
=09=09http://postgresql.1045698.n5.nabble.com= /How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5651436.html= =09
=09
=09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click here. =09=09NAML =09


=09 =09
=09
=09
=09
=09=09
If you reply to this email, your me= ssage will be added to the discussion below:
=09=09http://postgresql.1045698.n5.nabble.com= /How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5653287.html= =09
=09
=09=09 =09=09To unsubscribe from How to auto swtich the roles of primary and stand= by, click= here.
=09=09NAML =09
=09
View this message in context: Re:Re:Re: How to auto swtich the roles of primary and standby Sent from the PostgreSQL - admin mailing list archive at Nabble= .com.
------=_Part_55425_33535816.1334901702276--