Unambiguous identification of the cluster.

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Unambiguous identification of the cluster.
Date: 2012-02-11 19:27:15
Message-ID: CAAfz9KPM_tYr8Hgg1ATvr-KHF1+z2Brn39wXjTfNY0etWfJb0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all,

Is there are way to uniquely identify the cluster?
May be some identificator such as UUID?

PS.
I need to unambiguous identify the database.
There are current_catalog (and current_database())
function. There are also inet_server_addr() and
inet_server_port() functions, but these functions
returns NULL if the connection established via
socket. On the other hand, the server may be
configured to listen some port (not 5432) and
interface and if the connection established via
TCP/IP, these functions will returns non-NULL
values. So, it is not convenient (or even not
possible?) to unambiguous identify the cluster
on the client side (without knowledge about
default port and inteface which are listened
by particular Postgres server).

Any ideas?

--
// Dmitriy.

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2012-02-12 18:26:22 Regex match not back-referencing in function
Previous Message Terry Lee Tucker 2012-02-11 16:53:15 Re: question on trigger