Thread: Cannot create new link. Too many open links

I'm getting this error on PHP pages:

Warning: pg_connect(): Cannot create new link. Too
many open links (0).

In php.ini, pgsql.max_links = -1. Any idea what the
problem is? Something in postgresql.conf (I haven't
changed anything there yet)?

TIA,
CSN


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

NM - there was an old pgsql.so (7.3.2) getting in the
way. Beyond that, I don't what exactly the problem was
- some compiled-in setting?

CSN



--- CSN <cool_screen_name90001@yahoo.com> wrote:
> I'm getting this error on PHP pages:
>
> Warning: pg_connect(): Cannot create new link. Too
> many open links (0).
>
> In php.ini, pgsql.max_links = -1. Any idea what the
> problem is? Something in postgresql.conf (I haven't
> changed anything there yet)?
>
> TIA,
> CSN
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product
> search
> http://shopping.yahoo.com
>


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

>>I'm getting this error on PHP pages:
>>
>>Warning: pg_connect(): Cannot create new link. Too
>>many open links (0).
>>
>>In php.ini, pgsql.max_links = -1. Any idea what the
>>problem is? Something in postgresql.conf (I haven't
>>changed anything there yet)?

I saw this exact error just the other day on a Red Hat 9 system. It is a
PHP issue, not a Postgres one. The cause in my case was that I added:
   extension=pgsql.so
to /etc/php.ini, not realizing that Red Hat had patched PHP to look in
/etc/php.d, where it found the same line in a file called pgsql.ini. As
soon as I removed the extra reference, the error went away.

HTH,

Joe