Unwanted persisting connections

From: "Gary Hoffman" <ghoffman(at)ucsd(dot)edu>
To: pgsql-php(at)postgresql(dot)org
Subject: Unwanted persisting connections
Date: 2005-11-21 04:06:56
Message-ID: fc.00249f0e0172a6d63b9aca00edb8008f.172a744@irpsmail.ucsd.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

I've run PHP and PostgreSQL for quite a while and never seen this problem
before. I think it's new, but maybe I never paid attention to it before.

I am frequently running out of connections to the database. Here's a
snippet of my ps -ax

1882 ?? S 0:00.07 postgres: postgres cgssd_members [local] idle

1883 ?? S 0:00.09 postgres: postgres cgssd_members [local] idle

1884 ?? S 0:00.07 postgres: postgres cgssd_members [local] idle

1886 ?? S 0:00.14 postgres: postgres cgssd_members [local] idle

1887 ?? S 0:00.06 postgres: postgres cgssd_members [local] idle

500 std- S 0:01.14 /usr/local/bin/postmaster -D
/usr/local/pgsql/data
501 std- S 0:00.02 postgres: stats buffer process

502 std- S 0:00.21 postgres: stats collector process

As you can see, there are some idle connections that have come in from PHP
on my web pages. I've never seen these before and eventually they build up
and I get an error connecting from the PHP page to the database.

I'm running Apache 1.3.33 on Darwin Kernal 7.9.0 (MacOS X 10.3.9) with PHP
4.3.6 and PostgreSQL 7.4.2.

Ideas and suggestions are welcome.

Thanks,
Gary

**************************************************************************
* Gary B. Hoffman, Computing Services Manager e-mail: ghoffman(at)ucsd(dot)edu *
* Graduate School of International Relations and Pacific Studies (IR/PS) *
* University of California, San Diego (UCSD) voice: (858) 534-1989 *
* 9500 Gilman Dr. MC 0519 fax: (858) 534-3939 *
* La Jolla, CA 92093-0519 USA web: http://irps.ucsd.edu/ *
**************************************************************************

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message John DeSoi 2005-11-21 06:36:31 Re: postgres/php and windows
Previous Message Michael Glaesemann 2005-11-20 23:25:20 Re: postgres/php and windows