Re: i can't connect after some periode

--- On Thu, 7/10/08, aldy <aldy@teodore.com> wrote:

> From: aldy <aldy@teodore.com>
> Subject: Re: [SQL] i can't connect after some periode
> To: pgsql-sql@postgresql.org
> Date: Thursday, July 10, 2008, 8:16 AM
> From: "A. Kretschmer"
> <andreas.kretschmer@schollglas.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
> 
config parameters in postgres.conf

tcp_keepalives_idle (integer)
tcp_keepalives_interval (integer)
tcp_keepalives_count (integer)

http://www.postgresql.org/docs/8.3/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

> 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