On 07/03/2008, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
> > A bit of poking around with ps and lsof showed me that a PHP
> > application I closed days ago (no browser open) was still active
> > tying up backend sessions; the problem went away when I
> > restarted my apache. Is this "normal behaviour"? How do I
> > deal with it under normal circumstance, am I just supposed
> > to increase the number of allowed connections and not worry
> > about apache holding sessions open even after the "client"
> > has long gone?
> It depends on how you are connecting. For example if you are doing this:
>
> PDO::ATTR_PERSISTENT => true
>
> Then... yeah :). You really shouldn't use a language layer for
> persistent connections though. Use pgbouncer or pgpool.
Thanks Joshua. It was indeed set to true; I was playing with
the "hatshop" database and application from the "Beginning
PHP and PostgreSQL E-Commerce" Apress book. And found
that config.php has "define('DB_PERSISTENCY', 'true');". Thanks
for pointing me in the right direction.
> Joshua D. Drake
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
