Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f91Ms7n52183 for ; Mon, 1 Oct 2001 18:54:09 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 45A6E2AB45 for ; Mon, 1 Oct 2001 19:53:18 -0300 (GMT) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id C81032AB46; Mon, 1 Oct 2001 19:53:13 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: Subject: Re: persistent vs. non-persistent Date: Mon, 1 Oct 2001 19:53:11 -0300 X-Mailer: KMail [version 1.3] References: <20011001213819.82F8B2AB46@bugs.unl.edu.ar> <01a301c14ac2$908990d0$1e51000a@mitch> In-Reply-To: <01a301c14ac2$908990d0$1e51000a@mitch> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20011001225313.C81032AB46@bugs.unl.edu.ar> X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200110/10 X-Sequence-Number: 563 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 -----------------------------------------------------------------