DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.cn;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=X5vjTyygkEGS3JBLqAhqrrzJOqMS9JcNGxg9+zfKB7G9a7Sv0bB7piwsm3BvI2hqLbrarvTcwnUi9t+7V2flinI+XMdBOEGojXBWcCNT4WPUbHMXljSkke0OrOCCT1m90BTc+ScIu5RZGb6cHDscR+hp+2J20lmooBZaBFIY4Ik=;
Message-ID: <1336032308.94842.YahooMailClassic@web15607.mail.cnb.yahoo.com>
Date: Thu, 3 May 2012 16:05:08 +0800 (CST)
From: sgm <sgm277@yahoo.com.cn>
Subject: Re: postgresql stream replication question
To: =?utf-8?B?RGV2cmltIEfDnE5Ew5xa?= <devrim@gunduz.org>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <1336030440.4812.54.camel@lenovo01-laptop03.gunduz.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="787465216-1448026976-1336032308=:94842"

--787465216-1448026976-1336032308=:94842
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Thank you sir.

--- 12=E5=B9=B45=E6=9C=883=E6=97=A5=EF=BC=8C=E5=91=A8=E5=9B=9B, Devrim G=C3=
=9CND=C3=9CZ <devrim@gunduz.org> =E5=86=99=E9=81=93=EF=BC=9A

=E5=8F=91=E4=BB=B6=E4=BA=BA: Devrim G=C3=9CND=C3=9CZ <devrim@gunduz.org>
=E4=B8=BB=E9=A2=98: Re: [ADMIN] postgresql stream replication question
=E6=94=B6=E4=BB=B6=E4=BA=BA: "sgm" <sgm277@yahoo.com.cn>
=E6=8A=84=E9=80=81: pgsql-admin@postgresql.org
=E6=97=A5=E6=9C=9F: 2012=E5=B9=B45=E6=9C=883=E6=97=A5,=E5=91=A8=E5=9B=9B,=
=E4=B8=8B=E5=8D=883:34

On Thu, 2012-05-03 at 13:47 +0800, sgm wrote:
> I have successfully set up the stream replication M1--IP1, M2---IP2,
> my question is if the master is down, the slave will become read and
> write by trigger file, but the client will connect to the IP2,right?

No. You will need something else (like Red Hat Cluster Suite) for that.

Regards,
--=20
Devrim G=C3=9CND=C3=9CZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org=C2=A0 Twitter: http://twitter.com/devrimgunduz

--787465216-1448026976-1336032308=:94842
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Thank you sir.<br><br>--- <b>12=E5=B9=B45=E6=
=9C=883=E6=97=A5=EF=BC=8C=E5=91=A8=E5=9B=9B, Devrim G=C3=9CND=C3=9CZ <i>&lt=
;devrim@gunduz.org&gt;</i></b> =E5=86=99=E9=81=93=EF=BC=9A<br><blockquote s=
tyle=3D"border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-=
left: 5px;"><br>=E5=8F=91=E4=BB=B6=E4=BA=BA: Devrim G=C3=9CND=C3=9CZ &lt;de=
vrim@gunduz.org&gt;<br>=E4=B8=BB=E9=A2=98: Re: [ADMIN] postgresql stream re=
plication question<br>=E6=94=B6=E4=BB=B6=E4=BA=BA: "sgm" &lt;sgm277@yahoo.c=
om.cn&gt;<br>=E6=8A=84=E9=80=81: pgsql-admin@postgresql.org<br>=E6=97=A5=E6=
=9C=9F: 2012=E5=B9=B45=E6=9C=883=E6=97=A5,=E5=91=A8=E5=9B=9B,=E4=B8=8B=E5=
=8D=883:34<br><br><div class=3D"plainMail">On Thu, 2012-05-03 at 13:47 +080=
0, sgm wrote:<br>&gt; I have successfully set up the stream replication M1-=
-IP1, M2---IP2,<br>&gt; my question is if the master is down, the slave wil=
l become read and<br>&gt; write by trigger file, but the client will connec=
t to the IP2,right?<br><br>No. You will need something else (like Red Hat C=
luster Suite) for
 that.<br><br>Regards,<br>-- <br>Devrim G=C3=9CND=C3=9CZ<br>Principal Syste=
ms Engineer @ EnterpriseDB: <a href=3D"http://www.enterprisedb.com" target=
=3D"_blank">http://www.enterprisedb.com</a><br>PostgreSQL Dan=C4=B1=C5=9Fma=
n=C4=B1/Consultant, Red Hat Certified Engineer<br>Community: devrim~Postgre=
SQL.org, devrim.gunduz~linux.org.tr<br><a href=3D"http://www.gunduz.org" ta=
rget=3D"_blank">http://www.gunduz.org</a>&nbsp; Twitter: <a href=3D"http://=
twitter.com/devrimgunduz" target=3D"_blank">http://twitter.com/devrimgunduz=
</a><br></div></blockquote></td></tr></table>
--787465216-1448026976-1336032308=:94842--