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