Re: [GENERAL] is there anyway to get the backends IP address from the

2005-02-21 Thread Bruce Momjian
Steve Crawford wrote: > On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote: > > Added to TODO: > > > > * Add IP address to pg_stat_activity > > I like it. How about IP and port to differentiate multiple connections > from the same host? Will this support IPV6? Good point, added:

Re: [GENERAL] is there anyway to get the backends IP address from the

2005-02-18 Thread Steve Crawford
On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote: > Added to TODO: > > * Add IP address to pg_stat_activity I like it. How about IP and port to differentiate multiple connections from the same host? Will this support IPV6? Cheers, Steve ---(end of broadca

Re: [GENERAL] is there anyway to get the backends IP address from the

2005-02-12 Thread Bruce Momjian
Tony Caduto wrote: > Hi, > Does anyone know if there is a way to get the backends IP address from > the PID? > I am using the view pg_stat_activity and it would be nice if it would > also display the IP address along with the PID. > > I can see the IP address when I do a ps -ef but it would be n

Re: [GENERAL] is there anyway to get the backends IP address from the PID?

2005-01-15 Thread Michael Fuhr
On Fri, Jan 14, 2005 at 02:29:47PM -0600, Tony Caduto wrote: > Does anyone know if there is a way to get the backends IP address from > the PID? Do you mean the IP address of the backend (the server) or the address of the client that's using that backend? PostgreSQL 8.0 will have inet_client_ad

[GENERAL] is there anyway to get the backends IP address from the PID?

2005-01-14 Thread Tony Caduto
Hi, Does anyone know if there is a way to get the backends IP address from the PID? I am using the view pg_stat_activity and it would be nice if it would also display the IP address along with the PID. I can see the IP address when I do a ps -ef but it would be nice to be able to get it via a s