Hi SELECT inet_server_addr();
On Thu, Jun 14, 2012 at 4:43 PM, Guillaume Lelarge <guilla...@lelarge.info>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@postgresql.org) > 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
