From: Adam Alkins <postgresql@rasadam.com>
To: Johannes Alfänger <johannes.alfaenger@itwing.de>
Cc: pgsql-php@postgresql.org
Subject: Re: PHP and PostgreSQL: Cannot create new link. Too many open
Date: Wed, 28 Jan 2004 07:46:53 -0400
Message-ID: <4017A12D.2040104@rasadam.com> (raw)
In-Reply-To: <006301c3e581$501262f0$0c00000a@mandata.local>
References: <006301c3e581$501262f0$0c00000a@mandata.local>
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.comAttachments:postgresql.vcf (text/x-vcard, 337B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: postgresql@rasadam.com, johannes.alfaenger@itwing.de
Subject: Re: PHP and PostgreSQL: Cannot create new link. Too many open
In-Reply-To: <4017A12D.2040104@rasadam.com>
References: <006301c3e581$501262f0$0c00000a@mandata.local> <4017A12D.2040104@rasadam.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox