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

2005-02-21 Thread Oisin Glynn
have some idiotproofing. Is there info on what the check_function_bodies does check? Oisin - Original Message - From: "Bruce Momjian" To: <[EMAIL PROTECTED]> Cc: Sent: Monday, February 21, 2005 10:47 AM Subject: Re: [GENERAL] is there anyway to get the backends IP add

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

2005-02-21 Thread Bruce Momjian
Tony Caduto wrote: > Bruce, > On another note, is there plans to improve the type checking of stored > functions during the save/compile? > Currently I can pretty much make tons of mistakes (on purpose of course > :-) and they are not flagged as errors until runtime. > The biggest complaint I see

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

2005-02-20 Thread Tony Caduto
Bruce, On another note, is there plans to improve the type checking of stored functions during the save/compile? Currently I can pretty much make tons of mistakes (on purpose of course :-) and they are not flagged as errors until runtime. The biggest complaint I see from other DBAs (MS SQL, Oracl

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

2005-02-12 Thread Bruce Momjian
Berend Tober wrote: > > 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 ad

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

2005-02-12 Thread Berend Tober
> 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 woul

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