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

Re: i can't connect after some periode

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 (view raw, whole thread or download thread mbox)
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

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

In response to


pgsql-sql by date

Next:From: PostgreSQL AdminDate: 2008-07-10 12:50:23
Subject: Design and Question
Previous:From: A. KretschmerDate: 2008-07-10 07:14:04
Subject: Re: i can't connect after some periode

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