Re: libpq++ and Postgres

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