> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly