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

Re: lots of idle connections open by application

From: lst_hoe01(at)kwsoft(dot)de
To: PgSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: lots of idle connections open by application
Date: 2005-04-25 10:52:09
Message-ID: 20050425125209.i04m4d04k7k8ggk8@webmail.kwsoft.de (view raw or flat)
Thread:
Lists: pgsql-admin
Zitat von Gourish Singbal <gourish(at)gmail(dot)com>:

> Hi guys,
>
> We have an application using db-conection pooling through resin 2.1
> connecting to postgresql 7.4.5 database We have seen that after some
> time many connections are kept open in idle state. Sometimes the
> connections reach the max_connections = 100 and hence no more clients
> can connect to the database.
>
> Guys,  Whats a reasonable solution to this problem... ?

PgPool was suggested to me some time ago but i never tried it until now.

See http://pgpool.projects.postgresql.org/


Regards

Andreas



In response to

pgsql-admin by date

Next:From: SimpsonDate: 2005-04-25 11:49:08
Subject: Re: postmaster stop hangs
Previous:From: Gourish SingbalDate: 2005-04-25 10:21:15
Subject: lots of idle connections open by application

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