Message-ID: <54247889.8050002@aklaver.com>
Date: Thu, 25 Sep 2014 13:18:17 -0700
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.1.1
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: uuid for each postgres install?
References: <1925720361.922357.1411675347958.JavaMail.root@fmed.uba.ar>
In-Reply-To: <1925720361.922357.1411675347958.JavaMail.root@fmed.uba.ar>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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