From s5aly@yahoo.com Tue Jun 7 21:34:25 2011 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 89C63B5E0A1 for ; Tue, 7 Jun 2011 18:34:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 33569-07-3 for ; Tue, 7 Jun 2011 21:34:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm6.bullet.mail.ne1.yahoo.com (nm6.bullet.mail.ne1.yahoo.com [98.138.90.69]) by mail.postgresql.org (Postfix) with SMTP id D7C03B5F35F for ; Tue, 7 Jun 2011 18:34:04 -0300 (ADT) Received: from [98.138.90.56] by nm6.bullet.mail.ne1.yahoo.com with NNFMP; 07 Jun 2011 21:34:03 -0000 Received: from [98.138.89.248] by tm9.bullet.mail.ne1.yahoo.com with NNFMP; 07 Jun 2011 21:34:03 -0000 Received: from [127.0.0.1] by omp1040.mail.ne1.yahoo.com with NNFMP; 07 Jun 2011 21:33:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 621982.55995.bm@omp1040.mail.ne1.yahoo.com Received: (qmail 55392 invoked by uid 60001); 7 Jun 2011 21:33:53 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1307482433; bh=VwOJfmf02UnDljuEtR1L2imldztvO9JmEfcNL71KZTY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=jdc+dey5bNHv/2PWG/nRmYSz4OIx1Je+fsYvjOi+klt6Vmpphetl55yYYGWdl5qPfjcGPGUS7UBPuFEId9TkpjNKpiZJkzPNJk6owyAS23dKZv0+7FrhIYu9iv3Y5HCTC1BArv75kRb/zMdJ7hpNb07BQdkZWIsV0B82YAfvHc0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=eNli4GL0jJy3iQUx6WhhOliNqkcX+CO7I/T0IQ2Y1dLYv7Sa9yGcNvCcd3NPNr+PPgogw527cc5LUUZXPBPe+ydvQCH/HbRhwnZrQmkuZ2nZHF365GMJtZ4VLgpIEZ6osWDQRVrymKhK1GdUUypjtjzxjfYKwUaYxX/vpWGCyuQ=; Message-ID: <488118.23133.qm@web120004.mail.ne1.yahoo.com> X-YMail-OSG: gXoqXxIVM1mZQAld1eNWJme7jxbwd36wU9R9BC_NcONKwOX Q5vQwa2_tKt4NS5K.UNyWejDc.wi5AvJj7h92vRleNHQdDNLLN5UBRR4Tb4S BJaEpTgsE38Yt6Whay2acjpcukc9LUttQNOAZAk9TFV3TxVQOFGp3RYFB9rW Qr2RhculB9FhSnH4_qJlVXKlwacMfWHx2qj_giXdOFghGjc1PLdk_kCEon0b CClocqVFy92fv7xbDJtatEbw3Sd_xFu6q_b99AnO0RrpEnIqWKdGpb3Xvfgv MjaqViPv82r_7QtVroPhzB_cw_cNyKzrpHol8zEAROtZUVtbhzX8- Received: from [64.61.91.74] by web120004.mail.ne1.yahoo.com via HTTP; Tue, 07 Jun 2011 14:33:53 PDT X-Mailer: YahooMailRC/570 YahooMailWebService/0.8.111.304355 Date: Tue, 7 Jun 2011 14:33:53 -0700 (PDT) From: A J Subject: Sync replication waits for only 1 slave To: PG Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-236497708-1307482433=:23133" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.393 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, FS_REPLICA=3.599, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, SARE_SPEC_REPLICA=0.72, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: *** X-Archive-Number: 201106/39 X-Sequence-Number: 37665 --0-236497708-1307482433=:23133 Content-Type: text/plain; charset=us-ascii Hello Having a master and 2 slaves in synchronous replication mode in 9.1 The master seems to wait for only one slave to respond before considering the transaction to be complete. I have done the setting for master to wait for all the slaves to finish: synchronous_standby_names = '*' I even tried replacing * with both the slave application_names. Still master just waits for a single slave. Am I doing something incorrect or is it a limitation ? Thanks. AJ --0-236497708-1307482433=:23133 Content-Type: text/html; charset=us-ascii
Hello

Having a master and 2 slaves in synchronous replication mode in 9.1

The master seems to wait for only one slave to respond before considering the transaction to be complete. I have done the setting for master to wait for all the slaves to finish:
synchronous_standby_names = '*'
I even tried replacing * with both the slave application_names.

Still master just waits for a single slave. Am I doing something incorrect or is it a limitation ?

Thanks.
AJ
--0-236497708-1307482433=:23133-- From simon@2ndQuadrant.com Tue Jun 7 22:08:04 2011 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A2104B5F4E2 for ; Tue, 7 Jun 2011 19:08:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 66317-01-7 for ; Tue, 7 Jun 2011 22:07:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148110.authsmtp.com (outmail148110.authsmtp.com [62.13.148.110]) by mail.postgresql.org (Postfix) with ESMTP id 95BB4B5F34F for ; Tue, 7 Jun 2011 19:07:17 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt7.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p57M7Hdj092402 for ; Tue, 7 Jun 2011 23:07:17 +0100 (BST) Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com [209.85.216.181]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p57M7AOa010593 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=FAIL) for ; Tue, 7 Jun 2011 23:07:11 +0100 (BST) Received: by qyg14 with SMTP id 14so2765366qyg.19 for ; Tue, 07 Jun 2011 15:07:10 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.141.196 with SMTP id n4mr1548932qcu.257.1307484430744; Tue, 07 Jun 2011 15:07:10 -0700 (PDT) Received: by 10.229.21.137 with HTTP; Tue, 7 Jun 2011 15:07:10 -0700 (PDT) In-Reply-To: <488118.23133.qm@web120004.mail.ne1.yahoo.com> References: <488118.23133.qm@web120004.mail.ne1.yahoo.com> Date: Tue, 7 Jun 2011 23:07:10 +0100 Message-ID: Subject: Re: Sync replication waits for only 1 slave From: Simon Riggs To: A J Cc: PG Admin Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Server-Quench: 7ea18feb-9152-11e0-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MOFUSTAAU O0pfL1x7KFoHWV5D ViVKB0oLEgo/WWRq EU8PcgddY0teXQZg UE9DQ1McFgVhHxQE GBwfVAdzfwRZfXZ3 ekcsHnVcIUMLChd9 Q05RHG5IZmRjaC4Y BRFZf1UBIh5DfxpH d1F+AXMQaGJVNGdg R1VpYWxgYmUCcXRD eAxfZWE7bWMqOAt0 fAEEFn01EFUBRi46 Mx0hLBYDFUcNKQ08 NkFpXlQcIldLQhZa Fl9AaKDg X-Authentic-SMTP: 61633235383639.1014:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.419 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72 X-Spam-Level: ** X-Archive-Number: 201106/40 X-Sequence-Number: 37666 On Tue, Jun 7, 2011 at 10:33 PM, A J wrote: > Having a master and 2 slaves in synchronous replication mode in 9.1 > The master seems to wait for only one slave to respond before considering > the transaction to be complete. I have done the setting for master to wai= t > for all the slaves to finish: > synchronous_standby_names =3D '*' > I even tried replacing * with both the slave application_names. > Still master just waits for a single slave. Am I doing something incorrec= t > or is it a limitation ? No, its a design decision to improve availability and performance. You can list the second standby also, so it can take over in the event of failure. --=20 =A0Simon Riggs=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 http:/= /www.2ndQuadrant.com/ =A0PostgreSQL Development, 24x7 Support, Training & Services