On Sun, 14 Jan 2001, Peter Eisentraut wrote: > Thomas T. Thai writes: > > > i've noticed that when using php scripts or the "c" cgi search.cgi from > > mnogosearch, if i access either script from the web browser and stop it > > with ESC in the middle of it trying to access the pgsql db, the associated > > postmaster process hangs around forever and won't disappear: > > > > 19276 p1 I 0:00.11 postmaster: web mnwork [local] idle (postgres) > > 19920 p1 I 0:00.08 postmaster: web mnwork [local] idle (postgres) > > 19958 p1 I 0:00.10 postmaster: web mnwork [local] idle (postgres) > > These look like backend processes left around as part of the persistent > connection thing that PHP does. On the next connection they will get > reused, or so is the theory. most of the time they didn't get reused. some were from a C based cgi program too. i tried leaving them there for days and they never disappeared (no further access from php scripts or cgi)
