Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B8EFE1337B5B for ; Fri, 31 Dec 2010 08:57:41 -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 18686-04; Fri, 31 Dec 2010 12:57:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og111.obsmtp.com (exprod7og111.obsmtp.com [64.18.2.175]) by mail.postgresql.org (Postfix) with SMTP id 9DF1D1337B50; Fri, 31 Dec 2010 08:57:33 -0400 (AST) Received: from source ([209.85.215.44]) by exprod7ob111.postini.com ([64.18.6.12]) with SMTP ID DSNKTR3TPMTDOdOsBHTm1A5ipbnngsi/tMfN@postini.com; Fri, 31 Dec 2010 04:57:35 PST Received: by ewy8 with SMTP id 8so5476730ewy.31 for ; Fri, 31 Dec 2010 04:57:32 -0800 (PST) Received: by 10.213.16.208 with SMTP id p16mr10665388eba.73.1293800251975; Fri, 31 Dec 2010 04:57:31 -0800 (PST) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id t50sm12265548eeh.0.2010.12.31.04.57.30 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 31 Dec 2010 04:57:30 -0800 (PST) Message-ID: <4D1DD33A.8030404@enterprisedb.com> Date: Fri, 31 Dec 2010 14:57:30 +0200 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.1.15) Gecko/20101030 Icedove/3.0.10 MIME-Version: 1.0 To: Robert Haas CC: Simon Riggs , Greg Smith , Josh Berkus , Hannu Krosing , Stefan Kaltenbrunner , 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> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.2 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201012/2550 X-Sequence-Number: 177812 On 31.12.2010 14:40, Robert Haas wrote: > Someone may have proposed this before, but one way of getting standby > naming "for free" would be to make the standby names the same as the > roles used to log in, rather than adding a separate parameter. We > could just recommend to people that they use a separate, descriptive > role name for each standby. Then the synchronous_standbys parameter - > when added - would mean "a standby from one of these roles". Seems a bit weird. It's not a lot of effort to give each standby a name. But if you want something automatic, how about gethostname() ? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com