No idea. Let me CC this to the jdbc list.
Gabriel Dovalo Carril wrote:
>
> Hi,
>
> I've found a message, searching in google, you have sent last year,
> and I'n having the same problem you got.
> I would like to know if you have found a solution to it
>
> I'm using postgresql-7.0.3-6 and even having 36000 file descriptors
> available in the server, Postgres fails.
>
> What can be done?
>
> Thanks in advance.
>
> --
> Gabriel Dovalo.
>
> > [ Charset ISO-8859-1 unsupported, converting... ]
> > > I have a problem with postgres freeing resouces.
> > >
> > > Consider the following routine.
> > >
> > > int foo()
> > > {
> > > PgDatabase *pDatabase = new PgDatabase(cpDBName);
> > >
> > >
> > > // Use the connection, insert a record etc.
> > >
> > > delete pDatabase;
> > > }
> > >
> > > The delete call does not cause system resources to be freed, such
> > > as the socket connection. If you call this function about 1010 times,
> > > postgres will fail, stating that there are no system resources, too
> > > many open files.
> > >
> > > I am using postgrex 6.x
> > >
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026