Thread: psql timeout

psql timeout

From
"Yuri A. Kabaenkov"
Date:
Hello,

      how can i enable/change timeout on pgsql db connections?
      Where can i read about this?



------------
With respect,
Yuri A. Kabaenkov
hellman@artofit.com


Re: psql timeout

From
Martijn van Oosterhout
Date:
On Tue, Nov 27, 2001 at 12:08:04PM +0300, Yuri A. Kabaenkov wrote:
> Hello,
>
>       how can i enable/change timeout on pgsql db connections?
>       Where can i read about this?

There's a timeout? This must be a new feature. I regularly leave psql
sessions open overnight. Version 7.0.2 (yes it's old I know).

I must say, if a timeout has been added, I hope it can be disabled.

What exactly are you seeing?
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.

Re: psql timeout

From
Tom Lane
Date:
Martijn van Oosterhout <kleptog@svana.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