Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group