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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
