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.
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 |