Re: libpq++ and Postgres

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

Browse pgsql-interfaces by date

  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