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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Rob Richardson <RDRichardson(at)rad-con(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?
Date: 2012-06-14 21:43:44
Message-ID: 1339710224.2042.13.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hellmuth Vargas 2012-06-14 21:55:57 Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?
Previous Message david.sahagian 2012-06-14 21:07:38 parsing SQLERRM ?