X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 894B7D1B85F for ; Wed, 28 Jan 2004 11:47:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49058-04 for ; Wed, 28 Jan 2004 07:46:47 -0400 (AST) Received: from oxygen.nocdirect.com (oxygen.nocdirect.com [69.73.167.175]) by svr1.postgresql.org (Postfix) with ESMTP id 93D83D1D52A for ; Wed, 28 Jan 2004 07:46:39 -0400 (AST) Received: from cuscon3506.tstt.net.tt ([209.94.215.28] helo=rasadam.com) by oxygen.nocdirect.com with asmtp (Exim 4.24) id 1Alo9T-00051Z-73; Wed, 28 Jan 2004 05:46:35 -0600 Message-ID: <4017A12D.2040104@rasadam.com> Date: Wed, 28 Jan 2004 07:46:53 -0400 From: Adam Alkins User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-1?Q?Johannes_Alf=E4nger?= Cc: pgsql-php@postgresql.org Subject: Re: PHP and PostgreSQL: Cannot create new link. Too many open References: <006301c3e581$501262f0$0c00000a@mandata.local> In-Reply-To: <006301c3e581$501262f0$0c00000a@mandata.local> Content-Type: multipart/mixed; boundary="------------030606000006050502090709" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - oxygen.nocdirect.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - rasadam.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/27 X-Sequence-Number: 2543 This is a multi-part message in MIME format. --------------030606000006050502090709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Another Redhat user with your error wrote: --- In my /etc/php.ini file I had this line: extension=pgsql.so (now removed). ; Note: For Red Hat Linux, packaged extension modules are now loaded via ; the ini files in the directory /etc/php.d. # ls -l /etc/php.d -rw-r--r-- 1 root root 51 10 nov 16:40 pgsql.ini # cat /etc/php.d/pgsql.ini ; Enable pgsql extension module extension=pgsql.so Thank you for help! Now it's ok!! --- Hope that helps, Adam Johannes Alfänger wrote: >Hi All! > >After working with PHP and MySQL and Firebird quite a while I need to >install PostgreSQL. After installation I made a new build of PHP to >support >PostgreSQL. I looked over the ini files and re-started Apache. > >With psql I can connect like: "psql -h localhost ...". But not any >chancen >seen with PHP. I even just made a small script with just two echo lines >and >a pg_pconnect() / pg_connect(). > >This is the error Message I get: "Warning: pg_pconnect(): Cannot create >new >link. Too many open links (0). in /www/test.php on line 5". > >I get this message no matter what connection string I use. Even if I >leave >it totally blank or put some nonsense in, I get the same error. > >Any hint appreciated - Thanks in advance! Johannes > >Configuration: >Red Hat 9 >PHP Version 4.3.4 >Apache 2.0.48 >PostgreSQL 7.3.4 >PostgreSQL libpq 7.3.4 > >pg_hba.conf: >local all all trust >host all all 127.0.0.1 255.255.255.255 trust > > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > > > > -- Adam Alkins 1-868-627-9115 http://www.rasadam.com --------------030606000006050502090709 Content-Type: text/x-vcard; charset=utf8; name="postgresql.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="postgresql.vcf" begin:vcard fn:Adam Alkins n:Alkins;Adam org:Snikla enterprises;I.T. adr:;;#8 French Street;Woodbrook;;;Trinidad and Tobago email;internet:postgresql at (@) rasadam dot (.) com title:PHP Programmer tel;work:1-868-627-9115 tel;fax:1-868-627-9117 tel;cell:1-868-756-5173 x-mozilla-html:FALSE url:http://www.snikla.com version:2.1 end:vcard --------------030606000006050502090709--