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 or flat)
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??
> 

In response to

Responses

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-2014 The PostgreSQL Global Development Group