From: "A. Kretschmer" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2008 14:14
First, don't hijack other threads, your mail contains a
References-header:
owkay, i'm sorry for that
Maybe the clients do not close the connection and after some time you
have more than 'max_connections' (Default 100).
You can increase this value in your postgresql.conf.
You can also check, how many active connections are open with 'select *
from pg_stat_activity'.
Hope that helps, Andreas
thanks for the answer,
is there any procedure(utility) or configuration in postgresql which can
auto close for connection that idle for some minutes
thanks before
am Thu, dem 10.07.2008, um 13:57:15 +0700 mailte aldy folgendes:
hi all,
i have some problems with my postgresql database server :
i develop some client-server program using postgre as its database (used
by
almost 100 client), my problem comes after some periode of time( some
times
1 day) i can't connect to the database include from pgadmin, and i must
restart the server and everything back to normal ( im using Win XP as its
OS and postgre 8.2)
is there any suggetions for me, please??
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
