Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com [216.136.174.114]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5T23Fa37046 for ; Thu, 28 Jun 2001 22:03:15 -0400 (EDT) (envelope-from chrup999@yahoo.com) Received: from chill-025.bbnow.net (HELO ?192.168.0.4?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 29 Jun 2001 02:03:10 -0000 X-Apparently-From: User-Agent: Microsoft-Entourage/9.0.1.3108 Date: Thu, 28 Jun 2001 21:03:07 -0500 Subject: Re: Postgress jobs stick around after they have completed From: Chris Ruprecht To: Message-ID: In-Reply-To: <5592989937.20010625220919@techpilots.net> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200106/59 X-Sequence-Number: 456 on 06/25/2001 23:09, Jason k Larson at jlarson@techpilots.net wrote: > Hello - > > Your result of 1 means the close was (supposedly) successful. Not > sure why you have processes still running though. I would certainly > expect this pg_pconnect .. are you certain that nowhere else in the > script is attempting persistent connections? Or was using persistent > connections .. when in doubt .. try restarting Apache (apachectl > restart) and see if this process goes away (as it should if PHP > launched it, etc.) Ok - I found the bug - I did a pg_pconnect(...). After I changed that to a pg_connect, the session terminated upon pg_close( ... ). Since I have not quite been able to locate any docs on PHP-PG connections and their commands - why would I use a persistent connection? What can I do with it? Will it stay open until - when? Thanks for your help guys!! Chris _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com