> Is there a way to get the ip address of the connections > listed in pg_stat_activity?
It is - in 8.1 :)
Until then, I think you'll need to do a netstat -nap or such a commandand match the pids. Manually.
//Magnus