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... ?
pgsql-admin by date
|Next:||From: lst_hoe01||Date: 2005-04-25 10:52:09|
|Subject: Re: lots of idle connections open by application|
|Previous:||From: bernd.lentes||Date: 2005-04-25 08:35:40|
|Subject: Suse 9.2 stops booting while starting the postgres-server|