Thread: Close idle connections

Hi!

i want to know if there is possible to close idle
connections. I have some app in php but there is a lot of
open connections idleing and sometimes i get to many
connections.

--
lp,
 Uros                          mailto:uros@sir-mag.com

Hi,

On Thu, Jun 13, 2002 at 09:46:14PM +0200, Uros Gruber wrote:
> i want to know if there is possible to close idle
> connections. I have some app in php but there is a lot of
> open connections idleing and sometimes i get to many
> connections.
<apache-dir>/bin/apachectl graceful
closes all persistent connections.

-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

You're probably using pg_pconnects instead of pg_connects.  Unless you
REALLY need them AND know exactly what you are doing, pg_pconnects are
quite hazardous.

On Thu, 13 Jun 2002, Uros Gruber wrote:

> Hi!
>
> i want to know if there is possible to close idle
> connections. I have some app in php but there is a lot of
> open connections idleing and sometimes i get to many
> connections.
>
>

--
"Force has no place where there is need of skill.", "Haste in every
business brings failures.", "This is the bitterest pain among men, to have
much knowledge but no power." -- Herodotus

You need to check your php app and see if you have in each page a
pg_close($socket) statement. If your app uses persistent connections to
reduce execution times, you should have only one connection per user.
Horde/imp is one app that uses a lot of connections, so if this is your
application, try to see if a recent version of horde/imp corrects this
problem.

Uros Gruber a écrit :

> Hi!
>
> i want to know if there is possible to close idle
> connections. I have some app in php but there is a lot of
> open connections idleing and sometimes i get to many
> connections.
>
> --
> lp,
>  Uros                         mailto:uros@sir-mag.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

(See attached file: smime.p7s)