On 06/13/2012 09:33 PM, 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?
I am unaware of any such query. However "show listen_addresses;" might
allow you to achieve your goal.
Cheers,
Steve
