lots of idle connections open by application - Mailing list pgsql-admin

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