Received: from web13006.mail.yahoo.com (web13006.mail.yahoo.com [216.136.174.16]) by postgresql.org (8.11.3/8.11.4) with SMTP id f92EPPn66553 for ; Tue, 2 Oct 2001 10:25:25 -0400 (EDT) (envelope-from bmatzelle@yahoo.com) Message-ID: <20011002142522.75914.qmail@web13006.mail.yahoo.com> Received: from [146.145.232.35] by web13006.mail.yahoo.com via HTTP; Tue, 02 Oct 2001 07:25:22 PDT Date: Tue, 2 Oct 2001 07:25:22 -0700 (PDT) From: "Brent R. Matzelle" Subject: Re: persistent vs. non-persistent To: pgsql-php@postgresql.org In-Reply-To: <20011001213819.82F8B2AB46@bugs.unl.edu.ar> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200110/14 X-Sequence-Number: 567 --- 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