Skip site navigation (1) Skip section navigation (2)

connections running out

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

 

 

pgsql-odbc by date

Next:From: Scot LoachDate: 2005-08-30 17:56:48
Subject: Re: changed behavior in libpq odbc driver
Previous:From: operationsengineer1Date: 2005-08-30 17:32:34
Subject: New PGSQL and Linux Setup on Old Box

pgsql-admin by date

Next:From: Postgres AdminDate: 2005-08-30 17:59:04
Subject: Re: [SQL] plpgsql question
Previous:From: Michael FuhrDate: 2005-08-30 16:50:14
Subject: Re: plpgsql question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group