Postgres Pro
Downloads
Home   >   mailing lists

is there anyway to get the backends IP address from the PID? - Mailing list pgsql-general

From Tony Caduto
Subject is there anyway to get the backends IP address from the PID?
Date
Msg-id 41E82BBB.3090404@amsoftwaredesign.com
Whole thread Raw
In response to ntfs for windows port rc5-2  ("J. Greenlees" <jaqui@telus.net>)
Responses Re: is there anyway to get the backends IP address from the PID?
Re: is there anyway to get the backends IP address from the
List pgsql-general
Tree view 
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 by date:

Previous
From: Administrator
Date:
Subject: postmaster listening on specified addresses
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: MOVE