Re: persistent vs. non-persistent - Mailing list pgsql-php

From Mitch Vincent
Subject Re: persistent vs. non-persistent
Date
Msg-id 01a301c14ac2$908990d0$1e51000a@mitch
Whole thread Raw
In response to persistent vs. non-persistent  (Martín Marqués <martin@bugs.unl.edu.ar>)
Responses Re: persistent vs. non-persistent  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-php
> 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...

-Mitch



pgsql-php by date:

Previous
From: Martín Marqués
Date:
Subject: persistent vs. non-persistent
Next
From: Martín Marqués
Date:
Subject: Re: persistent vs. non-persistent