Re: dangling connections

On Tue, May 15, 2012 at 3:31 AM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:

> Try to do
>
> select client_addr, client_port from pg_stat_activity;
>
> after shutting down the Tomcat and find out what holds the <client_port> on
> the <client_addr>
>
> [user@<client_addr> ~]$ sudo netstat -pnao | grep <client_port>
>
> The second column from the right will be the process pid.
>
>
Thanks, I currently believe the client side does not hold the connection,
but I'll file this away for the next time it happens and I should have a
better picture.

--
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
http://www.opentempo.com
mailto:daryl(dot)stultz(at)opentempo(dot)com