Skip site navigation (1) Skip section navigation (2)

Re: PHP and PostgreSQL: Cannot create new link. Too many open

From: Adam Alkins <postgresql(at)rasadam(dot)com>
To: Johannes Alfänger <johannes(dot)alfaenger(at)itwing(dot)de>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: PHP and PostgreSQL: Cannot create new link. Too many open
Date: 2004-01-28 11:46:53
Message-ID: 4017A12D.2040104@rasadam.com (view raw or flat)
Thread:
Lists: pgsql-php
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


Attachment: postgresql.vcf
Description: text/x-vcard (339 bytes)

In response to

pgsql-php by date

Next:From: Johannes AlfängerDate: 2004-01-28 12:15:44
Subject: Re: PHP and PostgreSQL: Cannot create new link. Too many open links (0)
Previous:From: Johannes AlfängerDate: 2004-01-28 09:30:04
Subject: PHP and PostgreSQL: Cannot create new link. Too many open links (0)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group