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

From: Rob Richardson <RDRichardson(at)rad-con(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Is there a way to ask PostgreSQL for the name of the computer it's running on?
Date: 2012-06-14 04:33:09
Message-ID: 67D108EDFAD3C148A593E6ED7DCB4BBD1FDB0893@RADCONWIN2K8PDC.radcon.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

The computers are running Windows Server 2003.

Thank you very much.

RobR

Responses

Browse pgsql-general by date

  From Date Subject
Next Message utsav 2012-06-14 06:10:53 RETURNING MORE THAN ONE CUSTOM TYPE FROM FUNCTION
Previous Message Bruce Momjian 2012-06-14 02:49:17 Re: pg_upgrade: "pg_ctl failed to start the new server"