Postgres Pro
Downloads
Home   >   mailing lists

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

From lst_hoe01@kwsoft.de
Subject Re: lots of idle connections open by application
Date
Msg-id 20050425125209.i04m4d04k7k8ggk8@webmail.kwsoft.de
Whole thread Raw
In response to lots of idle connections open by application  (Gourish Singbal <gourish@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Gourish Singbal
Date:
Subject: lots of idle connections open by application
Next
From: "Simpson"
Date:
Subject: Re: postmaster stop hangs