psql timeout

Started by Yuri A. Kabaenkovover 24 years ago3 messagesgeneral
Jump to latest
#1Yuri A. Kabaenkov
sec@artofit.com

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

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Yuri A. Kabaenkov (#1)
Re: psql timeout

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/

Show quoted text

Terrorists can only take my life. Only my government can take my freedom.

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Martijn van Oosterhout (#2)
Re: psql timeout

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