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? As far as I know, you'd have to write a function in C, PL/PerlU or something similar that runs an OS command for you. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general