Skip site navigation (1) Skip section navigation (2)

Re: i can't connect after some periode

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org, aldy <aldy(at)teodore(dot)com>
Subject: Re: i can't connect after some periode
Date: 2008-07-10 14:22:41
Message-ID: 661466.45267.qm@web59505.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql


--- 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


      


In response to

Responses

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-07-10 14:48:20
Subject: Re: i can't connect after some periode
Previous:From: Lennin CaroDate: 2008-07-10 13:33:46
Subject: Re: i can't connect after some periode

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group