pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (5+ messages)  latest in thread

Message-ID: <Pine.LNX.4.33.0401161041370.27657-100000@css120.ihs.com>
Permalink:  ../Pine.LNX.4.33.0401161041370.27657-100000@css120.ihs.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.33.0401161041370.27657-100000@css120.ihs.com

 · 

reply

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