Skip site navigation (1) Skip section navigation (2)

Re: dangling connections

From: Daryl Stultz <daryl(dot)stultz(at)opentempo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: dangling connections
Date: 2012-05-15 11:47:09
Message-ID: CANYnOKQSS_0F6hd9-mEGU-BZi2zyVNicShJOXJqmXtTGwx2YPw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Daryl StultzDate: 2012-05-16 11:38:07
Subject: Re: dangling connections
Previous:From: Sergey KonoplevDate: 2012-05-15 07:31:31
Subject: Re: dangling connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group