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

Re: Too many open connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 15:53:30
Message-ID: 25722.979574010@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Petros Mylonopoulos <petros(at)gate(dot)v3(dot)com> writes:
> 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");


OK, it would seem that you are running into some limitation in PHP's
support for multiple connections to a database.  I don't know anything
about PHP, so I can't help you myself.  If you search for stuff about
PHP in the pgsql-interfaces mail list archives, you might find the
answer.  If no luck that way, I suggest asking about it on that list...

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Chris RyanDate: 2001-01-15 16:02:55
Subject: Re: Too many open connections
Previous:From: Petros MylonopoulosDate: 2001-01-15 15:49:52
Subject: Re: Too many open connections

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