Thread: lots of idle connections open by application

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... ?

--
Best,
Gourish Singbal

Zitat von Gourish Singbal <gourish@gmail.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