Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XXH1J-0002eL-Lp for pgsql-sql@arkaria.postgresql.org; Thu, 25 Sep 2014 21:56:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XXH1J-0007YE-1B for pgsql-sql@arkaria.postgresql.org; Thu, 25 Sep 2014 21:56:13 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XXH1H-0007Y5-T9 for pgsql-sql@postgresql.org; Thu, 25 Sep 2014 21:56:12 +0000 Received: from mail.fmed.uba.ar ([157.92.152.1] helo=azteca.fmed.uba.ar) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XXH1E-0005Tr-J6 for pgsql-sql@postgresql.org; Thu, 25 Sep 2014 21:56:10 +0000 Received: from localhost (localhost [127.0.0.1]) by azteca.fmed.uba.ar (Postfix) with ESMTP id 2341E5CA097; Thu, 25 Sep 2014 18:56:05 -0300 (ART) X-Virus-Scanned: amavisd-new at fmed.uba.ar Received: from azteca.fmed.uba.ar ([127.0.0.1]) by localhost (azteca.fmed.uba.ar [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id S+pJaz6L-8Xx; Thu, 25 Sep 2014 18:56:04 -0300 (ART) Received: from azteca.fmed.uba.ar (azteca.fmed.uba.ar [157.92.152.1]) by azteca.fmed.uba.ar (Postfix) with ESMTP id 0A0465CA0A4; Thu, 25 Sep 2014 18:56:01 -0300 (ART) Date: Thu, 25 Sep 2014 18:56:01 -0300 (ART) From: Gerardo Herzig To: Adrian Klaver Cc: pgsql-sql@postgresql.org Message-ID: <1020625502.926135.1411682161823.JavaMail.root@fmed.uba.ar> In-Reply-To: <54247889.8050002@aklaver.com> Subject: Re: uuid for each postgres install? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [186.136.211.207] X-Mailer: Zimbra 7.2.0_GA_2669 (ZimbraWebClient - GC36 (Linux)/7.2.0_GA_2669) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Well, thats are good news. At least its a good starting point. Thanks Adrian! Gerardo ----- Mensaje original ----- > De: "Adrian Klaver" > Para: pgsql-sql@postgresql.org > Enviados: Jueves, 25 de Septiembre 2014 17:18:17 > Asunto: Re: [SQL] uuid for each postgres install? > > On 09/25/2014 01:02 PM, Gerardo Herzig wrote: > > Hi all. Im wondering if there is, maybe at compilation time, some > > sort of unique identifier who identifies the actual installation. > > > > It would be even better if can be accesed in SQL form. > > At "initdb" time would be accepted, too. > > initdb does create a Database system identifier which can seen using > pg_controldata: > > postgres@killi:~> pg_controldata /usr/local/pgsql/data > pg_control version number: 903 > Catalog version number: 201008051 > Database system identifier: 5861256043884404217 > Database cluster state: shut down > > A quick search showed that folks would like an SQL way of getting > this > and that none is available as far as I can determine. The only > solution > I could find was grepping the pg_controldata output. > > > > > > > Thanks! > > > > Gerardo > > > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql