Received: from mail5.mx.voyager.net (mail5.mx.voyager.net [216.93.66.204]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f91Mvkn53119 for ; Mon, 1 Oct 2001 18:57:46 -0400 (EDT) (envelope-from mvincent@cablespeed.com) Received: from mitch (216-93-124-123.mdmmi.voyager.net [216.93.124.123]) by mail5.mx.voyager.net (8.11.6/8.10.2) with SMTP id f91Msxx81729; Mon, 1 Oct 2001 18:54:59 -0400 (EDT) Message-ID: <01d501c14acc$54b3d520$1e51000a@mitch> From: "Mitch Vincent" To: =?iso-8859-1?Q?Mart=EDn_Marqu=E9s?= , References: <20011001213819.82F8B2AB46@bugs.unl.edu.ar> <01a301c14ac2$908990d0$1e51000a@mitch> <20011001225313.C81032AB46@bugs.unl.edu.ar> Subject: Re: persistent vs. non-persistent Date: Mon, 1 Oct 2001 18:56:37 -0400 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.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Archive-Number: 200110/11 X-Sequence-Number: 564 I'm not sure about the internal workings, I see what you mean and will await your finding with great interest! -Mitch ----- Original Message ----- From: "Martín Marqués" To: Sent: Monday, October 01, 2001 6:53 PM Subject: Re: [PHP] persistent vs. non-persistent > On Lun 01 Oct 2001 18:46, you wrote: > > > I'm having headaches with PHP, postgres and persistent connections. > > > > They never have really worked for me, but I haven't tried with the recent > > PHP->PGSQL improvements.. > > > > > The problem is that my postgres backends stay alive after closing the > > > connection. > > > > That's what a persistant connection is, though... You'll have as many > > minimum PG backends hanging around as you do minimum apache backends (once > > that many PG backends get started, they hang around). > > > > > 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? > > > > Sure, don't use persistant connections..It sounds like they're the opposite > > of what you want... > > I've been all day looking for solid info on this case, and what I thought is > this: > > Is there a way to seek for open db connections? > > I don't understand why apache (or PHP) doesn't see that it has a persistent > database connection open to use. > > I'm checking the PHP PGSQL extensions at this moment. > More info later.... > > Saludos.... ;-) > > -- > Porqué usar una base de datos relacional cualquiera, > si podés usar PostgreSQL? > ----------------------------------------------------------------- > Martín Marqués | mmarques@unl.edu.ar > Programador, Administrador, DBA | Centro de Telematica > Universidad Nacional > del Litoral > ----------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >