From: scott.marlowe <scott.marlowe@ihs.com>
To: mauro.folcarelli@sistinf.it
Cc: pgsql-php@postgresql.org
Subject: Re: pg_connect(): Cannot create new link
Date: Fri, 16 Jan 2004 10:42:47 -0700 (MST)
Message-ID: <Pine.LNX.4.33.0401161041370.27657-100000@css120.ihs.com> (raw)
In-Reply-To: <OF59FF32EA.71E3C9D3-ONC1256E1B.00508E59@sistinf.it>
On Wed, 14 Jan 2004 mauro.folcarelli@sistinf.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?
What does
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
pg_ctl start
and see if you can connect.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: scott.marlowe@ihs.com, mauro.folcarelli@sistinf.it
Subject: Re: pg_connect(): Cannot create new link
In-Reply-To: <Pine.LNX.4.33.0401161041370.27657-100000@css120.ihs.com>
References: <OF59FF32EA.71E3C9D3-ONC1256E1B.00508E59@sistinf.it> <Pine.LNX.4.33.0401161041370.27657-100000@css120.ihs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox