Unwanted persisting connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  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.


* Gary B. Hoffman, Computing Services Manager  e-mail: ghoffman@xxxxxxxx *
* 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/ *

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux