is there anyway to get the backends IP address from the PID?

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема is there anyway to get the backends IP address from the PID?
Дата
Msg-id 41E82BBB.3090404@amsoftwaredesign.com
обсуждение исходный текст
Ответ на ntfs for windows port rc5-2  ("J. Greenlees" <jaqui@telus.net>)
Ответы Re: is there anyway to get the backends IP address from the PID?  (Michael Fuhr <mike@fuhr.org>)
Re: is there anyway to get the backends IP address from the  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Hi,
Does anyone know if there is a way to get the backends IP address from
the PID?
I am using the view pg_stat_activity and it would be nice if it would
also display the IP address along with the PID.

I can see the IP address when I do a ps -ef but it would be nice to be
able to get it via a sql command.

Thanks,

Tony Caduto
http://www.amsoftwaredesign.com

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

Предыдущее
От: Administrator
Дата:
Сообщение: postmaster listening on specified addresses
Следующее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: MOVE