Re: Too many open connections

From: Petros Mylonopoulos <petros(at)gate(dot)v3(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Too many open connections
Date: 2001-01-15 15:49:52
Message-ID: Pine.BSF.4.21.0101151639550.37960-100000@gate.v3.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?
------------------------------------------------------------

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-15 15:53:30 Re: Too many open connections
Previous Message Tom Lane 2001-01-15 15:35:01 Re: Too many open connections