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