From: | Ranjan Kumar Baisak <rbaisak(at)nyc(dot)yamaha(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | autoReconnect with PostGres |
Date: | 2007-05-22 19:40:51 |
Message-ID: | 46534743.9020601@nyc.yamaha.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Group,
I am using postgres in my web application. Number
of physical DB connections are just getting increased for each
re-deployment of my web application. I generally dont shutdown my
webserver and only re-deploy my web application. I heard that
"autoReconnect = true" reuses idle connections for each redeployments. I
am not sure whether this can help me to make physical DB connections
constant.
My configuration parameters:
<Resource
name="jdbc/XXXX"
scope="Shareable"
type="javax.sql.DataSource"
url="jdbc:postgresql://mydb.test.com/micms"
validationQuery="select tablename from pg_tables where schemaname
= 'gpdb'"
maxIdle="10"
maxActive="20"
maxWait="-1"
driverClassName="org.postgresql.Driver"
removeAbandoned="true"
username="xxxx"
logAbandoned="true"
removeAbandonedTimeout="120"
password="xxxx" />
Your help would be highly appreciated.
regards,
Ranjan
From | Date | Subject | |
---|---|---|---|
Next Message | Pablo Hume | 2007-05-22 20:19:55 | Call a program |
Previous Message | Robert Fitzpatrick | 2007-05-22 19:31:13 | Re: Permance issues with migrated db |