Thread: PHP and PostgreSQL: Cannot create new link. Too many open links (0)

PHP and PostgreSQL: Cannot create new link. Too many open links (0)

From
Johannes Alfänger
Date:
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


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

From
Adam Alkins
Date:
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

Re: PHP and PostgreSQL: Cannot create new link. Too many open links (0)

From
Johannes Alfänger
Date:
Thanks everyone for the quick help! It did the trick!

BTW: I search the list archive for the error message in any thinkable
way - but I did not get that thread in the result set.

Cheers - Johannes

On Wednesday 28 January 2004 02:30, you wrote:
> 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".