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

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

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

This is a multi-part message in MIME format.
--------------030606000006050502090709
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
X-MIME-Autoconverted: from 8bit to quoted-printable by commandprompt.com id i0SBlV0n026023

Another Redhat user with your error wrote:

---
In my /etc/php.ini file I had this line:

extension=3Dpgsql.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=3Dpgsql.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
>
>
>
> =20
>


--=20
Adam Alkins
1-868-627-9115
http://www.rasadam.com


--------------030606000006050502090709
Content-Type: text/x-vcard; charset=utf8;
name="postgresql.vcf"
Content-Disposition: attachment;
filename="postgresql.vcf"
Content-Transfer-Encoding: 7bit

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
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--------------030606000006050502090709--

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

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".


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)