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