Postgres Pro
Downloads
Home   >   mailing lists

Re: backends and pg_stat_activity - Mailing list pgsql-general

From Magnus Hagander
Subject Re: backends and pg_stat_activity
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E757@algol.sollentuna.se
Whole thread Raw
In response to backends and pg_stat_activity  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: fine tuned database dump/reload?
Next
From: Chris Browne
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase