From: | "aldy" <aldy(at)teodore(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: i can't connect after some periode |
Date: | 2008-07-10 08:16:53 |
Message-ID: | 004401c8e265$50cb8ab0$c801a8c0@italdy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>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??
>
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Admin | 2008-07-10 12:50:23 | Design and Question |
Previous Message | A. Kretschmer | 2008-07-10 07:14:04 | Re: i can't connect after some periode |