Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6DAA3476169 for ; Thu, 31 Oct 2002 03:09:47 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id D97E9476167 for ; Thu, 31 Oct 2002 03:09:45 -0500 (EST) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g9V8EBs03487; Thu, 31 Oct 2002 10:14:11 +0200 Date: Thu, 31 Oct 2002 10:14:11 +0200 (EET) From: Achilleus Mantzios To: jack Cc: pgsql-sql@postgresql.org Subject: Re: time limit of a database connection In-Reply-To: <004301c280a8$f253bb70$1400a8c0@jac> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/418 X-Sequence-Number: 10135 On Thu, 31 Oct 2002, jack wrote: > I use a window client to conncet to a postgreSQL server with windows ODBC. > It seems if I haven't done anything on the connection for hours, the > connection will be dropped. Is that possible to set the time limit of a > connection? Thank you in advance! In the same manner that pgsql backends dont close connections initiated by a psql client, the same should apply to your case. Maybe it is your client's issue. > > Jack > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr