From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Sent: Thursday, July 10, 2008 14:14
>First, don't hijack other threads, your mail contains a
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
> 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
>> almost 100 client), my problem comes after some periode of time( some
>> 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??
In response to
pgsql-sql by date
|Next:||From: PostgreSQL Admin||Date: 2008-07-10 12:50:23|
|Subject: Design and Question|
|Previous:||From: A. Kretschmer||Date: 2008-07-10 07:14:04|
|Subject: Re: i can't connect after some periode|