From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | PostgreSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Cc: | Gabriel Dovalo Carril <dovalo(at)teleline(dot)es> |
Subject: | Re: libpq++ and Postgres |
Date: | 2002-03-04 19:46:39 |
Message-ID: | 200203041946.g24Jkea27368@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Oops, libpq++. Let me CC the interfaces list.
---------------------------------------------------------------------------
pgman wrote:
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Hubert Palme | 2002-03-04 20:34:25 | PL/pgSQL Syntax Problem |
Previous Message | Tom Lane | 2002-03-04 02:43:13 | Re: libpgtcl pg_execute |