Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5441C1337B5C for ; Tue, 4 Jan 2011 18:18:48 -0400 (AST) 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 18186-08 for ; Tue, 4 Jan 2011 22:18:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149057.authsmtp.net (outmail149057.authsmtp.net [62.13.149.57]) by mail.postgresql.org (Postfix) with ESMTP id E2E3D1337B4F for ; Tue, 4 Jan 2011 18:18:40 -0400 (AST) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p04MIdRe053585; Tue, 4 Jan 2011 22:18:40 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p04MIOgg026416; Tue, 4 Jan 2011 22:18:30 GMT Message-ID: <4D239CA5.70504@postgresql.org> Date: Tue, 04 Jan 2011 14:18:13 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Dimitri Fontaine CC: Heikki Linnakangas , Stefan Kaltenbrunner , Simon Riggs , greg@2ndQuadrant.com, Hannu Krosing , Robert Haas , pgsql-hackers@postgresql.org Subject: Re: Sync Rep Design References: <1293729972.1892.23804.camel@ebony> <4D1CC47E.7050207@kaltenbrunner.cc> <1293735853.1892.24886.camel@ebony> <4D1D8B2F.5070001@2ndquadrant.com> <4D1DAB14.5000800@enterprisedb.com> <1293796137.1892.37313.camel@ebony> <4D1DCF5A.7070808@enterprisedb.com> <1293822959.1892.43164.camel@ebony> <4D1F332A.90306@kaltenbrunner.cc> <4D1FAD55.1090304@postgresql.org> <4D2038BB.7000504@enterprisedb.com> <4D236999.4050905@postgresql.org> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 906df7a9-1850-11e0-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IjsDFzNPUwg+PxkK BgUMOw5HJEYITQBc chYbOAIPd38VQxYD A2cKS1ZWWlx5U2B3 JQxVcw1cfEhKWhtr UUlWQFdQERpoT1wB AmNnLU4ldwdAfH92 K0dgWXNdEk16cxIr RR9dCGwOYGd9aWFK UF1RcFEGbQNKfB1D bll4XHYMaStlM3Bw LC8aFBMcBw5qYB9E RApFF18KCWoGBT8z QXj7 X-Authentic-SMTP: 61633136333939.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=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/287 X-Sequence-Number: 178124 > What about the HBA here? Hmmm. That's tempting; an "synchronous" HBA instead of a GUC? But that doesn't solve the problem of "standby #6 is failing, I want to kick it off synch rep". I'd be opposed to having a GUC *and* an HBA. making DBAs set things independantly in two places just frustrates our users. --Josh