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

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


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