Re: libpq++ and Postgres
От | Bruce Momjian |
---|---|
Тема | Re: libpq++ and Postgres |
Дата | |
Msg-id | 200203041946.g24Jkea27368@candle.pha.pa.us обсуждение исходный текст |
Список | 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 по дате отправления: