Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VF3pB-0002v3-8e for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Aug 2013 15:07:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VF3pA-0000xt-Mv for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Aug 2013 15:07:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VF3p9-0000xf-IM for pgsql-hackers@postgresql.org; Thu, 29 Aug 2013 15:07:51 +0000 Received: from 99-153-64-76.uvs.austtx.sbcglobal.net ([99.153.64.76] helo=noel.decibel.org) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VF3p2-0006L1-Vy for pgsql-hackers@postgresql.org; Thu, 29 Aug 2013 15:07:48 +0000 Received: from decina.local (cpe-66-68-80-207.austin.res.rr.com [66.68.80.207]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTPSA id 137666D45D; Thu, 29 Aug 2013 15:07:34 +0000 (UTC) Message-ID: <521E8EB9.3070908@nasby.net> Date: Wed, 28 Aug 2013 18:58:49 -0500 From: Jim Nasby User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:17.0) Gecko/20130801 Thunderbird/17.0.8 MIME-Version: 1.0 To: Fujii Masao CC: Michael Paquier , Greg Stark , Hannu Krosing , Tom Lane , Andres Freund , Alvaro Herrera , Josh Berkus , PostgreSQL-development Subject: Re: pg_system_identifier() References: <5215346B.7070800@dalibo.com> <20130822134205.GC17006@awork2.anarazel.de> <52163222.9030700@agliodbs.com> <20130822155633.GF17006@awork2.anarazel.de> <14611.1377187563@sss.pgh.pa.us> <20130822161839.GG17006@awork2.anarazel.de> <20130822162019.GC10710@eldon.alvh.no-ip.org> <20130822163059.GI17006@awork2.anarazel.de> <15653.1377189456@sss.pgh.pa.us> <52177AD5.5010809@2ndQuadrant.com> <521A8985.2040509@nasby.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 8/26/13 8:48 AM, Fujii Masao wrote: >>> I think it's also noteworthy that Slony and londiste both rely on the user >>> >>specifying node identifiers. They don't try to be magic about it. I think >>> >>there's 2 advantages there: >>> >> >>> >>- Code is simpler >>> >>- Users can choose a naming schema that makes sense for them >> >Definitely agreed on that. > A user can already specify the unique standby name by using > application_name in primary_conninfo. So, the remaining thing > that we should do is to expose the primary_conninfo, i.e., > commit the merge-recovery.conf-into-postgresql.conf patch ;P Is uniqueness actually enforced there? I believe that was part of the original problem... -- Jim C. Nasby, Data Architect jim@nasby.net 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers