[imp] Postgres and Persistent Conections

Rich Lafferty rich@horde.org
Thu, 1 Mar 2001 21:06:04 -0500


On Thu, Mar 01, 2001 at 07:21:04PM -0300, Alexander E. Belck (alexb@iol.psi.br) wrote:
> > I'm trying to use horde-1.2.4 with imp-2.2.4 with Postgres wher I still
> > (I'm upgrading from 1.2.3/2.2.3) have problems with persistent conections.
> > I searched all documents and found that .../hord/imp/lib/db.pgsql at
> > function imp_open_pg_db() still use 'pg_pconnect'.
> > 
> > I tryed to modify this to 'pg_connect' but this generates a lot of erros
> > when I try to login at IMP.

*What* errors? Changing all occurrences of 'pg_pconnect' to
'pg_connect' is not only okay, but has already been done in cvs. We
use it here on a machine that gets up to two thousand logins a day
with no problems at all. 

I suspect the errors are related to something else (like, say, running
out of postgres connections -- you're not using the default of 32
backends/32 buffers, are you?)

  -Rich

-- 
------------------------------ Rich Lafferty ---------------------------
 Sysadmin/Programmer, Instructional and Information Technology Services
   Concordia University, Montreal, QC                 (514) 848-7625
------------------------- rich@alcor.concordia.ca ----------------------