RE: FW: URGENT: pgsql on the web server - memory proble ms....

Yes, it sounds like a persistent connection problem with PHP.  I know they
help with load speed of postgres, but we have had problems with them.  

> -----Original Message-----
> From:	Gunnar R|nning [SMTP:gunnar@candleweb.no]
> Sent:	Thursday, October 05, 2000 8:35 AM
> To:	Nikolay Mijaylov
> Cc:	pgsql-general@postgresql.org
> Subject:	Re: [GENERAL] FW: URGENT: pgsql on the web server - memory
> problems....
> 
> "Nikolay Mijaylov"  writes:
> 
> > The problem is that PHP is auto killing after a while (1-2 min), but the
> pos
> > tgres backend process stay (and works about 2 or many more hours). Soon
> all
> > Linux is filled with 64 postgres processes, free memory is 0 and Linux,
> free
> > ze :)
> > 
> 
> The postgres backend processes should die when the connections are
> closed. Are you sure that the process that runs PHP doesn't keep the
> connections open ? You should check open ports using netstat -a and maybe
> go on using lsof to check the client processes. 
> 
> regards, 
> 
> 	Gunnar