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: (view raw, whole thread or download thread mbox)
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/ on line 63

Line 63 of 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

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

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


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-2017 The PostgreSQL Global Development Group