Close idle connections

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)