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" <bmatzelle@xxxxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> Sent: Tuesday, October 02, 2001 9:25 AM Subject: Re: [PHP] persistent vs. non-persistent > --- Martín Marqués <martin@xxxxxxxxxxxxxxx> 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
