backends and pg_stat_activity

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 command
and match the pids. Manually.

//Magnus