Re: psql timeout

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: "Yuri A(dot) Kabaenkov" <sec(at)artofit(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: psql timeout
Date: 2001-11-27 15:03:58
Message-ID: 18821.1006873438@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> On Tue, Nov 27, 2001 at 12:08:04PM +0300, Yuri A. Kabaenkov wrote:
>> how can i enable/change timeout on pgsql db connections?

> There's a timeout?

No, there isn't. Other than the timeouts specified by TCP, if you're
using a TCP connection. (We do set SO_KEEPALIVE to ensure that a
lost connection will be recognized even if no data transmission is
pending, but I believe the spec timeout for that is ~ 1 hour.)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2001-11-27 15:04:41 Re: Timing a query
Previous Message Antonio Sergio de Mello e Souza 2001-11-27 14:37:20 Re: Pl/Pgsql triger procedure calls with parameters