#25628 [Fbk->Opn]: Cannot Connect to postgres database
| From: | matt at coffeecup dot com | Date: | Mon, 22 Sep 2003 18:59:14 +0000 |
| Subject: | #25628 [Fbk->Opn]: Cannot Connect to postgres database | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-47958@lists.php.net to get a copy of this message | ||
ID: 25628
User updated by: matt at coffeecup dot com
Reported By: matt at coffeecup dot com
-Status: Feedback
+Status: Open
Bug Type: PostgreSQL related
Operating System: Red Hat Enterprise Linux ES 2.1
PHP Version: 4.3.3
New Comment:
This version had the exact same problem.
Previous Comments:
------------------------------------------------------------------------
[2003-09-22 12:23:20] sniper@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
------------------------------------------------------------------------
[2003-09-22 11:58:16] matt at coffeecup dot com
Description:
------------
I upgraded to php 4.3.3, and started receiving this error when
connecting to postgres:
PHP Warning: pg_connect(): Cannot create new link. Too many open links
(0).
I use the same configure line with php 4.3.2:
./configure --with-apxs=/usr/local/apache/bin/apxs --with-curl
--with-xml --with-mysql=/usr --with-ssl --with-mcrypt
--enable-xslt-sablot --with-gd --with-jpeg-dir=/usr/bin/cjpeg
--with-zlib --with-ttf --with-pgsql
php.ini file remains the same:
; Maximum number of links (persistent+non persistent). -1 means no
limit.
pgsql.max_links = -1
When I re-install 4.3.2, the problem goes away.
Reproduce code:
---------------
$bd_db = pg_connect ("host=$hostname dbname=$database_name
user=$username password=$password");
Expected result:
----------------
A connection to the database given
Actual result:
--------------
PHP Warning: pg_connect(): Cannot create new link. Too many open links
(0).
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25628&edit=1