Re: idle connections

On Mon, Oct 5, 2009 at 5:50 PM, Aras Angelo <araskoktas(at)gmail(dot)com> wrote:
> Its a regular pg_connect()
>
> When i kill the earliest idle process the others stop too. So i dont know
> whats wrong really. All our apps use the same footer, with pg_close() at the
> end.
>
> I have done most of the things you guys suggested, so it seems to me that
> something between php-apache-postgresql is not doing good, and it only
> effects us at peak times, so just wondering if killing processes every 2-3
> minutes, would do harm on our setup.
>
> I have 3 apache servers reading from one single db server.

php automagically cleans up old connections etc upon script exit, so
either your scripts aren't exiting, or they're crashing before they
can exit I'd guess. Or you've got a REALLY busy apache server that
has that many connections open at once.

Anything in your apache or php logs that offers a clue?