Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by postgresql.org (8.11.3/8.11.4) with SMTP id f92F3Hn81098 for ; Tue, 2 Oct 2001 11:03:17 -0400 (EDT) (envelope-from chrup999@yahoo.com) Received: from proxy.compucom.com (HELO Z161842) (204.214.145.2) by smtp.mail.vip.sc5.yahoo.com with SMTP; 2 Oct 2001 15:03:13 -0000 X-Apparently-From: Message-ID: <008601c14b53$4c1507e0$5dd26383@corp.compucom.com> From: "Chris Ruprecht" To: References: <20011002142522.75914.qmail@web13006.mail.yahoo.com> Subject: Re: persistent vs. non-persistent Date: Tue, 2 Oct 2001 10:02:47 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200110/16 X-Sequence-Number: 569 Brent, given, that you keep the connection open indefinitely, how do you use it? Do I go and $db = pg_pconnect(...); when I first start apache and then never do a connect again, unless I re-start apache? How would I query if a connection already exists? Best regards, Chris ----- Original Message ----- From: "Brent R. Matzelle" To: Sent: Tuesday, October 02, 2001 9:25 AM Subject: Re: [PHP] persistent vs. non-persistent > --- Martín Marqués wrote: > > I'm having headaches with PHP, postgres and persistent > > connections. > > > > The problem is that my postgres backends stay alive after > > closing the > > connection. > > The connection is never closed if it is a persistent connection. > Even if you use pg_close it remains open. > > > I use pg_pconnect to connect to the database, put after > > closing the > > conection, nothing happens, la backend stays alive, and all I > > can do is > > restart apache to make them close (really close). > > > > Any solution to this? > > This is exactly the behavior to expect from a persistent > connection. This is not a bug. If you do not want this > behavior then simply use pg_connect rather than pg_pconnect. > > Brent > > __________________________________________________ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com