Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id CF46E1E4344F for ; Thu, 3 May 2012 02:48:10 -0300 (ADT) Received: from nm4-vm2.bullet.mail.sg3.yahoo.com ([106.10.148.129]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SPotb-0004BU-Rx for pgsql-admin@postgresql.org; Thu, 03 May 2012 05:48:09 +0000 Received: from [106.10.166.112] by nm4.bullet.mail.sg3.yahoo.com with NNFMP; 03 May 2012 05:47:52 -0000 Received: from [106.10.151.187] by tm1.bullet.mail.sg3.yahoo.com with NNFMP; 03 May 2012 05:47:52 -0000 Received: from [127.0.0.1] by omp1013.mail.sg3.yahoo.com with NNFMP; 03 May 2012 05:47:52 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 715592.93871.bm@omp1013.mail.sg3.yahoo.com Received: (qmail 76016 invoked by uid 60001); 3 May 2012 05:47:52 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.cn; s=s1024; t=1336024072; bh=LjispZA3HsNFptPGWZZu7q/fe9wLRutcJpnESlKN7Bc=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=MIsNdnZzkpqRMQF8o0yiEoJvZ0BMmPDGAGWaqX2912YJeu0UPQGeXsNZA+lbv+h2xx1tmzgDMuWKxyLDK2aRWKHmrQJnYGVghJfhYETmUFHGp8h9/ZLQnH/rUtzWgEr+2vsoBKytu0mCLDEGFE2ZKogg1JunXrhtqt08nRRTKKw= 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:MIME-Version:Content-Type; b=O/veU8PIU5t8VdAGy5bQy0pNiSO0v59I2yGx3LDOB9zDB4axlOY4cE9KbeFa8Q2RKtM9hCpfQQUeKM2Fqrqs0eCJj81us/xr7mig1OicVkZNz9zpv7pAEr/GvlhaaubbkXsM7kORcNP59xx5AU5PTEXI7W4fq5nmsCm/ZHMsYgg=; X-YMail-OSG: bF4wsiYVM1l.82BauD4AmHkBkJTGdKkRUA3_vVPhJcfhRt8 ftWWQjUgMfqXzqR6m8Hf1UDvPWstqnCvcGD77EccyVQyRb_gDOmULl2W1K7s k0dfZGQ7OJ44j.qwMNLA5ZrNciXQZI.zA0aOtmfIc4DV4Lz0jAhlLCPqgZAX 2JuSzRHQKnZCSC17ELbWbuwf2ou8zvTzQ4YN_VUKWJBaqZBBlsuaV8Ohnpuc Cfj8sPm5U2d.hLv8uAXkgQRj_cLdcgeaghtx.jMJ_dL9GIvR3WEEBkT1ddm4 ddtdcPyueRQ8Ch7_bwdL6Oxas.geRMCTP4Lr9BXzbwLpRSfQ2V1a2dXbSoYw mnft_PClfDI_l6JQ3d5FTw7b88kj932Xl1_8h_GIIVT_KvR270lnpVAEeWEq 6vxf_XoU4nxnhEb0xZE2LLs0_lsnv7KY- Received: from [218.241.169.34] by web15608.mail.cnb.yahoo.com via HTTP; Thu, 03 May 2012 13:47:52 CST X-Mailer: YahooMailClassic/15.0.6 YahooMailWebService/0.8.117.340979 Message-ID: <1336024072.75926.YahooMailClassic@web15608.mail.cnb.yahoo.com> Date: Thu, 3 May 2012 13:47:52 +0800 (CST) From: sgm Subject: postgresql stream replication question To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1134129794-259346682-1336024072=:75926" X-Pg-Spam-Score: 1.1 (+) X-Archive-Number: 201205/11 X-Sequence-Number: 39500 ---1134129794-259346682-1336024072=:75926 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Dear admin, I have successfully set up the stream replication M1--IP1, M2---IP2, my que= stion is if the master is down, the slave will become read and write by tri= gger file, but the client will connect to the IP2,right? Thanks, Song ---1134129794-259346682-1336024072=:75926 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Dear admin,

I have success= fully set up the stream replication M1--IP1, M2---IP2, my question is if th= e master is down, the slave will become read and write by trigger file, but= the client will connect to the IP2,right?

Thanks,=

Song
---1134129794-259346682-1336024072=:75926--