Postgres Pro
Downloads
Home   >   mailing lists

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

From Guillaume Lelarge
Subject Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?
Date
Msg-id 1339710224.2042.13.camel@localhost.localdomain
Whole thread Raw
In response to Is there a way to ask PostgreSQL for the name of the computer it's running on?  (Rob Richardson <RDRichardson@rad-con.com>)
Responses Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?
List pgsql-general
Tree view 
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
noway in our system to determine which one it is running on.  The third computer sometimes needs to know which of the
othertwo computers is active.  It would be enough to know which computer is running the PostgreSQL service.  Is the
nameof 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

pgsql-general by date:

Previous
From:
Date:
Subject: parsing SQLERRM ?
Next
From: Hellmuth Vargas
Date:
Subject: Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?