Search Postgresql Archives

Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

SELECT inet_server_addr();

On Thu, Jun 14, 2012 at 4:43 PM, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:
On Thu, 2012-06-14 at 04:33 +0000, Rob Richardson wrote:
> My customer has 3 computers.  The PostgreSQL service could be running on either of two of them.  There is currently no way in our system to determine which one it is running on.  The third computer sometimes needs to know which of the other two computers is active.  It would be enough to know which computer is running the PostgreSQL service.  Is the name of the server available in a PostgreSQL database, so that it could be retrieved using a query?
>

You can have its IP address, but not its name, unless you write a C or
PL/perlU function.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Cordialmente,

Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet
PostgreSQL DBA

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux