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.

--0-236497708-1307482433=:23133--