Re: persistent vs. non-persistent

Поиск
Список
Период
Сортировка
От Brent R. Matzelle
Тема Re: persistent vs. non-persistent
Дата
Msg-id 20011002142522.75914.qmail@web13006.mail.yahoo.com
обсуждение исходный текст
Ответ на persistent vs. non-persistent  (Martín Marqués <martin@bugs.unl.edu.ar>)
Список pgsql-php
--- Mart�n Marqu�s <martin@bugs.unl.edu.ar> 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

В списке pgsql-php по дате отправления:

Предыдущее
От: Andrew McMillan
Дата:
Сообщение: Re: persistent vs. non-persistent
Следующее
От: "Brent R. Matzelle"
Дата:
Сообщение: Re: persistent vs. non-persistent