Persistent Connections with PHP and PostgreSQL

From: Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)br>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Persistent Connections with PHP and PostgreSQL
Date: 2002-02-06 16:34:58
Message-ID: A1D265B81E168745B876193655F97F8D01809A@mvescexc01.esc.multivalor.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.)??

Thanks

Felipe Nascimento
MultiValor.com.br
Tel.: 55 21 2505 3900 / 2505 3911
Fax: 55 21 2505 3910
<mailto:felipe(dot)nascimento(at)multivalor(dot)com(dot)br>
<http://www.multivalor.com.br>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-02-06 17:34:05 Re: pg_restore
Previous Message Tom Lane 2002-02-06 16:33:30 Re: pg_restore