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]
On 06/13/2012 09:33 PM, Rob Richardson wrote:
I am unaware of any such query. However "show listen_addresses;"
might allow you to achieve your goal.
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?
[PHP on Windows]
[Find Someone Nice]
[Postgresql & PHP]