Re: Too many open connections - Mailing list pgsql-novice

From Petros Mylonopoulos
Subject Re: Too many open connections
Date
Msg-id Pine.BSF.4.21.0101151639550.37960-100000@gate.v3.com
Whole thread Raw
In response to Re: Too many open connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Too many open connections
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Too many open connections
Next
From: Tom Lane
Date:
Subject: Re: Too many open connections