Re: [ADMIN] dangling connections

2012-05-15 Thread Sergey Konoplev
On Mon, May 14, 2012 at 8:58 PM, Daryl Stultz wrote: > Hello, > > I have a tomcat server with 7 applications connecting to PG 8.4. All apps > use connection pooling. Over the weekend the apps ran out of connections. > The max connections is at the default of 100 which is more than enough for > nor

Re: [ADMIN] dangling connections

2012-05-15 Thread Daryl Stultz
On Tue, May 15, 2012 at 3:31 AM, Sergey Konoplev wrote: > Try to do > > select client_addr, client_port from pg_stat_activity; > > after shutting down the Tomcat and find out what holds the on > the > > [user@ ~]$ sudo netstat -pnao | grep > > The second column from the right will be the proce