| From: | "Joel Fradkin" <jfradkin(at)wazagua(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | connections running out |
| Date: | 2005-08-30 17:35:39 |
| Message-ID: | 005b01c5ad89$3dcf7ca0$797ba8c0@jfradkin |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-odbc |
My install using the new driver (ODBC) seems to have helped me a great deal.
Unfortunately one of my night jobs uses a dynamic cube product that does a
record set.
I am not certain but I have the feeling it is leaving the connection open.
After a few days (always at night when the program runs) I end up running
out of connections (was set to 600 I upped it a bit).
Is there something I can do to ensure they get closed in a given period of
time?
Joel Fradkin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Postgres Admin | 2005-08-30 17:59:04 | Re: [SQL] plpgsql question |
| Previous Message | Michael Fuhr | 2005-08-30 16:50:14 | Re: plpgsql question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scot Loach | 2005-08-30 17:56:48 | Re: changed behavior in libpq odbc driver |
| Previous Message | operationsengineer1 | 2005-08-30 17:32:34 | New PGSQL and Linux Setup on Old Box |