Re: Persistent Connections with PHP and PostgreSQL

From: Phill Kenoyer <pgsql(at)c0de(dot)net>
To: Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)br>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Persistent Connections with PHP and PostgreSQL
Date: 2002-02-06 18:24:16
Message-ID: 20020206182416.GO27030@home.c0de.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Its a bug in PHP. Also, PHP 4.1.1 is the latest version. I have not
tried it with this new version yet. I switched from pconnect to just
connect and I did not see much difference. I dont run into the out of
connections problem any more so I'm happy.

|On 020206 10:00
|Felipe Nascimento (Felipe(dot)Nascimento(at)multivalor(dot)com(dot)br) wrote the following...
|
|Dears,
|
|I am using PostgreSQL 7.1.3 with PHP4.0.6.
|I'm trying to establish persistent connections with pg_pconnect() function
|from PHP.
|There are some problems like there was too many connections being
|established. Sometimes I get a warning "Supplied argument is not a valid
|PostgreSQL link resource in...". Other times, when I try to connect with
|psql, I get "Sorry, too many clients".
|
|Suggestions?
|
|Is it better to use persistent connections over normal connections (despite
|the fact that I have to close all the normal connections whenever I open
|one.)??
--
BOFH Reason of the day: We only support a 28000 bps connection.
_ | _
(_()(|('.|)('||.|()|`|(

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Manav 2002-02-06 18:28:01 pg_dump version
Previous Message Tom Lane 2002-02-06 17:34:05 Re: pg_restore