#25628 [Opn->Fbk]: Cannot Connect to postgres database

ID: 25628 Updated by: iliaa@php.net Reported By: matt at coffeecup dot com -Status: Open +Status: Feedback Bug Type: PostgreSQL related Operating System: Red Hat Enterprise Linux ES 2.1 PHP Version: 4.3.3 New Comment: How many apache children do you have at maximum and how many connections (at maximum) does your postgreSQL allow to connect? Previous Comments: ------------------------------------------------------------------------ [2003-09-22 14:59:13] matt at coffeecup dot com This version had the exact same problem. ------------------------------------------------------------------------ [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