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.
In response to
pgsql-admin by date
|Next:||From: Simpson||Date: 2005-04-25 11:49:08|
|Subject: Re: postmaster stop hangs |
|Previous:||From: Gourish Singbal||Date: 2005-04-25 10:21:15|
|Subject: lots of idle connections open by application|