Re: libpq++ and Postgres - Mailing list pgsql-interfaces

From Bruce Momjian
Subject Re: libpq++ and Postgres
Date
Msg-id 200203041946.g24Jkea27368@candle.pha.pa.us
Whole thread Raw
List 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@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

--  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,
Pennsylvania19026
 


pgsql-interfaces by date:

Previous
From: "Shabnam Nisha"
Date:
Subject: Error running script
Next
From: "Ted Petrosky"
Date:
Subject: help understanding libpq++