Re: Too many open connections

Поиск
Список
Период
Сортировка
От Petros Mylonopoulos
Тема Re: Too many open connections
Дата
Msg-id Pine.BSF.4.21.0101151639550.37960-100000@gate.v3.com
обсуждение исходный текст
Ответ на Re: Too many open connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Too many open connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
> What PG version are you using, on what platform?  Exactly when and where
> does this message show up?

We're running the last i386 debian linux, kernel v2.4.0, pgsql 7.0.2.
The errormessage pop up whenever the database is connected for image
withdrawal. It's all over the website. When the database was running on
slowaris7 we did not get these errors. Just increidibly high load, which I
"fixed" by using kernel parameters for Oracle 8.0.5

We've got a website which retrieves it's images and user info from a pgsql
database. The full error message is

Warning: PostgreSQL: Too many open links (2) in
/opt/apache/www/jippy/db.inc.php on line 63

Line 63 of db.inc.php is the last of the 3 following:

function Open ($host, $user, $pass, $db) {
       $port = "5432";
       $this->_db_linkid = pg_Connect ("host=$host port=$port dbname=$db user=$user password=$pass");

Pgsql and apache are not running on the same machine, in case you were
wondering.

>             regards, tom lane
Thnx for the speedy reply. Hope I gve enough info.

Grtz,
P. Mylonopoulos
Trilab BV / V3
Javastraat 2c
2585AM Den Haag
Tel: +31-70-3457123

------------------------------------------------------------
Who is General Failure?
And why is he reading my disk?
------------------------------------------------------------


В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Too many open connections
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Too many open connections