On Wed, 14 Jan 2004 mauro(dot)folcarelli(at)sistinf(dot)it wrote:
> I have the same problem posted by James Ward (Date: Mon, 15 Sep 2003)
> I migrated from (postgresql-7.3.2-3 and php-4.2.2-17) to
> (postgresql-7.3.4-2 and php-4.3.3-6).
> When I connect to the Database via php, I get the following message:
> Warning: pg_connect(): Cannot create new link. Too many open links (0).
> I didn't change any configuration file: everything used to work.
> It's the first connection to the database
> (max connections should be 32 by default).
> Is it a bug ? Any solution?
> Is there a chance to bypass it?
ps ax|grep postgres|wc -l
say? If it says 34 or so, then yes, you have that many connections. You
may have a problem with your apache processes hanging / dying oddly and
keeping the postgresql connections open. restart postgresql with
pg_ctl -m fast stop
and see if you can connect.
In response to
pgsql-php by date
|Next:||From: ljb||Date: 2004-01-17 01:04:39|
|Subject: Re: pg_connect(): Cannot create new link|
|Previous:||From: Enrico Ortmann||Date: 2004-01-16 10:30:23|
|Subject: can't create db|