libpq++

Started by Belcher, Jimabout 25 years ago2 messagesgeneral
Jump to latest
#1Belcher, Jim
JBelcher@elastic.com

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

Thanks

#2Bruce Momjian
bruce@momjian.us
In reply to: Belcher, Jim (#1)
Re: libpq++

Can you try 7.0.X or 7.1 beta and let us know if it is still a problem?

[ 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

Thanks

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