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

Re: Too many open connections

From: Chris Ryan <chris(at)greatbridge(dot)com>
To: Petros Mylonopoulos <petros(at)gate(dot)v3(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Too many open connections
Date: 2001-01-15 16:02:55
Message-ID: 3A631F2F.5DBA9255@greatbridge.com (view raw or flat)
Thread:
Lists: pgsql-novice
	This looks very much like the PHP limit of open connections per
process. You can look in the php.ini file for "pgsql.max_links" and you
should see what it is configured for.

	Also without seeing the entire code (i'll make a few assumptions) it
appears that the code is within a ?class? and I didn't see any checks to
see if there was already a connection to the database. You may want to
check to see if a connection has already been made within that class and
close it before opening a new one. This however may not be the cause if
you are creating a new class each time thereby creating a new
connection. Without knowing more about what it is you are trying to do
and how you are doing it hard to really say if it is the best way or a
better way to do it.

	Hope this helps a little.

Chris Ryan
chris(at)greatbridge(dot)com

Petros Mylonopoulos wrote:
> 
> > 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: Petros MylonopoulosDate: 2001-01-15 16:21:55
Subject: Re: Too many open connections
Previous:From: Tom LaneDate: 2001-01-15 15:53:30
Subject: Re: Too many open connections

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