Re: i can't connect after some periode

--- On Thu, 7/10/08, aldy <aldy(at)teodore(dot)com> wrote:

> From: aldy <aldy(at)teodore(dot)com>
> Subject: Re: [SQL] i can't connect after some periode
> To: pgsql-sql(at)postgresql(dot)org
> Date: Thursday, July 10, 2008, 8:16 AM
> 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
>
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql