Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 24602125F9C9
	for <pgsql-admin@postgresql.org>; Thu, 19 Apr 2012 07:47:39 -0300 (ADT)
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <videanuadrian@yahoo.com>) id 1SKotn-0005Me-0L
	for pgsql-admin@postgresql.org; Thu, 19 Apr 2012 10:47:39 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <videanuadrian@yahoo.com>) id 1SKota-000718-4s
	for pgsql-admin@postgresql.org; Thu, 19 Apr 2012 03:47:26 -0700
Date: Thu, 19 Apr 2012 03:47:26 -0700 (PDT)
From: videanuadrian <videanuadrian@yahoo.com>
To: pgsql-admin@postgresql.org
Message-ID: <1334832426.97159.YahooMailClassic@web160205.mail.bf1.yahoo.com>
In-Reply-To: <348c54fa.6443.136c8731742.Coremail.jenopob@126.com>
References: <1309678517759-4546630.post@n5.nabble.com>
	<1334641370515-5645680.post@n5.nabble.com>
	<348c54fa.6443.136c8731742.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_41283_14313327.1334832446145"
X-Pg-Spam-Score: 0.9 (/)
X-Archive-Number: 201204/101
X-Sequence-Number: 39437

------=_Part_41283_14313327.1334832446145
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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] <ml-node+s1045698n5650704h68@=
n5.nabble.com> wrote:

From: jenopob [via PostgreSQL] <ml-node+s1045698n5650704h68@n5.nabble.com>
Subject: Re:Re: How to auto swtich the roles of primary and standby
To: "videanuadrian" <videanuadrian@yahoo.com>
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

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-t=
o-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5651436.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
------=_Part_41283_14313327.1334832446145
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">so, just to make sure that i understand: <br>=
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 ?<br><br>--- On <b>Thu, 4/19/12, jenopob [via PostgreSQL]=
 <i>&lt;<a href=3D"/user/SendEmail.jtp?type=3Dnode&node=3D5651436&i=3D0" ta=
rget=3D"_top" rel=3D"nofollow" link=3D"external">[hidden email]</a>&gt;</i>=
</b> wrote:<br><blockquote style=3D"border-left: 2px solid rgb(16, 16, 255)=
; margin-left: 5px; padding-left: 5px;"><br>From: jenopob [via PostgreSQL] =
&lt;<a href=3D"/user/SendEmail.jtp?type=3Dnode&node=3D5651436&i=3D1" target=
=3D"_top" rel=3D"nofollow" link=3D"external">[hidden email]</a>&gt;<br>Subj=
ect: Re:Re: How to auto swtich the roles of primary and standby<br>To: "vid=
eanuadrian" &lt;<a href=3D"/user/SendEmail.jtp?type=3Dnode&node=3D5651436&i=
=3D2" target=3D"_top" rel=3D"nofollow" link=3D"external">[hidden email]</a>=
&gt;<br>Date: Thursday, April 19, 2012, 5:34 AM<br><br><div id=3D"yiv748628=
468">

=09<div style=3D"line-height: 1.7; color: rgb(0, 0, 0); font-size: 14px; fo=
nt-family: arial;"><div>hi</div><div>&nbsp;</div><div>we did a new shell sc=
ript named recovery_config_chage.sh at standby server.</div><div>the script=
 I wanted to change the fail down postgres master config ,let it start as s=
tandby server</div><div>and build the communication with the former standby=
 now is master server,then started it by remotestart.sh&nbsp;</div><div>&nb=
sp;</div><div>the above hopes to help you something</div><div>&nbsp;</div><=
div id=3D"yiv748628468divNeteaseMailCard"></div><div></div>At 2012-04-17 13=
:42:50,"videanuadrian&nbsp;[via&nbsp;PostgreSQL]"&nbsp;&lt;<a rel=3D"nofoll=
ow" target=3D"_top" link=3D"external">[hidden email]</a>&gt; wrote:<br> <bl=
ockquote style=3D"border-left: 2px solid rgb(204, 204, 204); padding: 0pt 1=
em;" id=3D"yiv748628468isReplyContent">

=09Hi there,=20
<br>i have the exact same problem. Did you find a solution for this ?
<br>thanks,
<br>Adrian Videanu
=09
=09<br>
=09<br>
=09<hr noshade=3D"noshade" size=3D"1" color=3D"#cccccc">
=09<div style=3D"font: 12px tahoma,geneva,helvetica,arial,sans-serif; color=
: rgb(68, 68, 68);">
=09=09<div style=3D"font-weight: bold;">If you reply to this email, your me=
ssage will be added to the discussion below:</div>
=09=09<a rel=3D"nofollow" target=3D"_blank" href=3D"http://postgresql.10456=
98.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546=
630p5645680.html" link=3D"external">http://postgresql.1045698.n5.nabble.com=
/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5645680.html=
</a>
=09</div>
=09<div style=3D"font: 11px/1.5em tahoma,geneva,helvetica,arial,sans-serif;=
 color: rgb(102, 102, 102); margin-top: 0.4em;">
=09=09
=09=09To unsubscribe from How to auto swtich the roles of primary and stand=
by, <a rel=3D"nofollow" target=3D"_top" link=3D"external">click here</a>.<b=
r>
=09=09<a rel=3D"nofollow" style=3D"font: 9px serif;" target=3D"_blank" href=
=3D"http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=
=3Dmacro_viewer&amp;id=3Dinstant_html%21nabble%3Aemail.naml&amp;base=3Dnabb=
le.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-=
nabble.view.web.template.NodeNamespace&amp;breadcrumbs=3Dnotify_subscribers=
%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_em=
ail%21nabble%3Aemail.naml" link=3D"external">NAML</a>
=09</div></blockquote></div><br><br><span title=3D"neteasefooter"><span id=
=3D"yiv748628468netease_mail_footer"></span></span>
=09
=09<br>
=09<br>
=09<hr noshade=3D"noshade" size=3D"1" color=3D"#cccccc">
=09<div style=3D"color: rgb(68, 68, 68); font: 12px tahoma,geneva,helvetica=
,arial,sans-serif;">
=09=09<div style=3D"font-weight: bold;">If you reply to this email, your me=
ssage will be added to the discussion below:</div>
=09=09<a rel=3D"nofollow" target=3D"_blank" href=3D"http://postgresql.10456=
98.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546=
630p5650704.html" link=3D"external">http://postgresql.1045698.n5.nabble.com=
/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5650704.html=
</a>
=09</div>
=09<div style=3D"color: rgb(102, 102, 102); font: 11px/1.5em tahoma,geneva,=
helvetica,arial,sans-serif; margin-top: 0.4em;">
=09=09
=09=09To unsubscribe from How to auto swtich the roles of primary and stand=
by, <a rel=3D"nofollow" target=3D"_blank" href=3D"" link=3D"external">click=
 here</a>.<br>
=09=09<a rel=3D"nofollow" target=3D"_blank" href=3D"http://postgresql.10456=
98.n5.nabble.com/template/NamlServlet.jtp?macro=3Dmacro_viewer&amp;id=3Dins=
tant_html%21nabble%3Aemail.naml&amp;base=3Dnabble.naml.namespaces.BasicName=
space-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.Nod=
eNamespace&amp;breadcrumbs=3Dnotify_subscribers%21nabble%3Aemail.naml-insta=
nt_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" s=
tyle=3D"font: 9px serif;" link=3D"external">NAML</a>
=09</div></div></blockquote></td></tr></table>
=09
<br/><hr align=3D"left" width=3D"300" />
View this message in context: <a href=3D"http://postgresql.1045698.n5.nabbl=
e.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5651436=
.html">Re:Re: How to auto swtich the roles of primary and standby</a><br/>
Sent from the <a href=3D"http://postgresql.1045698.n5.nabble.com/PostgreSQL=
-admin-f2076596.html">PostgreSQL - admin mailing list archive</a> at Nabble=
.com.<br/>
------=_Part_41283_14313327.1334832446145--