Skip site navigation (1) Skip section navigation (2)

re: PHP and persistent connections

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
To: jmcazurin <mikah(at)info(dot)com(dot)ph>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: re: PHP and persistent connections
Date: 2000-11-27 16:55:58
Message-ID: Pine.BSF.4.21.0011270853270.60076-100000@oddjob.adhesivemedia.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-novice
You could set MaxRequestsPerChild in apache's httpd.conf.  This controls
how many requests each apache process is allowed to serve.  After it
serves this many the process dies which should close the postgres process
as well (if it isn't, you have other problems). 

I know that for a long time Apache recommened setting this fairly low on
Solaris due to a memory leak in solaris...ideally you'd want to set this
really high, but setting it low will make the processes die...

-philip

On Fri, 24 Nov 2000, jmcazurin wrote:

> 
> At 12:47 PM 11/24/00, GH wrote:
> >On Fri, Nov 24, 2000 at 03:17:59PM +1100, some SMTP stream spewed forth:
> > > Oh, and if you are using pg_close() I don't think it works
> > > in any currently released PHP4 versions. See:
> >
> >This seems to be true. I ran into some fun link errors while
> >connecting and disconnecting more than once in a script.
> 
>    This sounds disturbing!
> 
>    How then should I go about closing persistent connections? Can I close 
> them at all?
> 
>    Would pg_close() work if I used it on non-persistent connections?
> 
>    Thanks in advance,
> 
> Mikah
> 


In response to

pgsql-novice by date

Next:From: Philip HallstromDate: 2000-11-27 16:57:23
Subject: Re: Re: re : PHP and persistent connections
Previous:From: Yoghini ThevarajahDate: 2000-11-27 16:49:36
Subject: Share tables between different databases

pgsql-hackers by date

Next:From: Philip HallstromDate: 2000-11-27 16:57:23
Subject: Re: Re: re : PHP and persistent connections
Previous:From: Ross J. ReedstromDate: 2000-11-27 16:46:08
Subject: Re: Re: [NOVICE] Re: re : PHP and persistent connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group