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: (view raw, whole thread or download thread mbox)
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.

In response to


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-2017 The PostgreSQL Global Development Group