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

Поиск
Список
Период
Сортировка
От Rob Richardson
Тема Is there a way to ask PostgreSQL for the name of the computer it's running on?
Дата
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBD1FDB0893@RADCONWIN2K8PDC.radcon.local
обсуждение исходный текст
Ответы Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Is there a way to ask PostgreSQL for the name of the computer it's running on?  (aasat <satriani@veranet.pl>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade: "pg_ctl failed to start the new server"
Следующее
От: utsav
Дата:
Сообщение: RETURNING MORE THAN ONE CUSTOM TYPE FROM FUNCTION