Re: backends and pg_stat_activity

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Joseph Shraibman" <jks(at)selectacast(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: backends and pg_stat_activity
Date: 2005-10-17 20:40:02
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E757@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2005-10-17 20:53:37 Re: [pgsql-advocacy] Oracle buys Innobase
Previous Message Vivek Khera 2005-10-17 20:35:53 Re: fine tuned database dump/reload?