Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 284C29FB5B9 for ; Wed, 28 Feb 2007 12:01:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 09469-01-4 for ; Wed, 28 Feb 2007 12:00:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 5B4709FBCF4 for ; Wed, 28 Feb 2007 12:01:02 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so143636ugf for ; Wed, 28 Feb 2007 08:01:01 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=C+TD9hgufMWrJOYHcPh6TsDfBdTT/fJaVhLNQnIsABoFl2a8k8WnEsMu/ln8zcUDb6I051st2Sv17pQVIlq8iCSMwGYGIjJNOdGJd6g4AoNm9OXopG2mBgJ74lu9bRXveDs2kMjY6i8fRAiwi4Tsq89bGMhenHsDWE9L+2qc/QU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=W1K+3vHo+PNEoB+uZFlrrE9Qdj88chDVsxRauHpubdLxlSIcN35X0414ton/ZX1e/i6PZeTeyIgje1s2CEgRypxHJzZubXvZe0qtENuhhvLCOZETxJ5ZOFhsSS5JTenCVWaT37ty68ZM0nH4AZfrX7XwgQdHJV2Wdmfyax9GEFg= Received: by 10.66.244.11 with SMTP id r11mr915208ugh.1172678461152; Wed, 28 Feb 2007 08:01:01 -0800 (PST) Received: by 10.67.94.13 with HTTP; Wed, 28 Feb 2007 08:01:01 -0800 (PST) Message-ID: <55c095e90702280801q484b75d8v3833a18c5d5a5c16@mail.gmail.com> Date: Wed, 28 Feb 2007 13:01:01 -0300 From: "Ezequias Rodrigues da Rocha" To: "Goran Rakic" Subject: Re: Disconnecting non active (IDLE ) users Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/344 X-Sequence-Number: 24809 I would like to know how postgresql defines that a connection is inactive. I have the same problem but in the future I couldn't restart my server every day. Any explanation ? Ezequias 2007/2/26, Goran Rakic : > I have installed POSTGRESQL 8.2 on W2K3 32bit , 100 users connecting from > desktop applications and 200 users connecting thru web service from handh= eld > computers > > I have problem with second groups of users. > > Often they do not disconnect from POSTGRE Server and with time passing th= ru > I have lot of IDLE users and very much memory consumptions. From time to > time that can crash server then only restarting server will kill all > postgres.exe from memory and this annoying me, because that I build scrip= t > to restart server every night. I could not get programmers to change > program. > > > > Is there parameters which will disconnect IDLE users if they excided some > time or some program which will purge memory from non active posgres.exe > > > > Thanks in advance > > > > gossa@disyu.com > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/