Re: Timing out connections?

From: Len Walter <len(dot)walter(at)gmail(dot)com>
To: Peter Fein <pfein(at)pobox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Aaron Lav <asl2(at)pobox(dot)com>
Subject: Re: Timing out connections?
Date: 2005-08-19 08:34:03
Message-ID: 25b9fbe9050819013428757790@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I used pgpool for a similar problem. It has an option for timing out
idle connections.

Len

On 8/19/05, Peter Fein <pfein(at)pobox(dot)com> wrote:
> Hi-
>
> Is there any way to have the *server* timeout disconnected clients? I'm
> connecting over a sometimes flaky WiFi connection & when it goes down,
> I'm left with several open idle sessions. Is there a way to have the
> server disconnect these? A coworker and I have searched the docs/faqs &
> haven't been able to find an answer. The best we could come up with was
> tunneling over SSH and lowering sshd's timeout setting, but this seems
> less than ideal. TIA.
>
> --Pete
>
> --
> Peter Fein pfein(at)pobox(dot)com 773-575-0694
>
> Basically, if you're not a utopianist, you're a schmuck. -J. Feldman
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
Len Walter len(dot)walter(at)gmail(dot)com http://crookedtimbre.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-08-19 08:55:48 Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a file
Previous Message Sean Utt 2005-08-19 08:10:46 Re: [GENERAL] BUG #1830: Non-super-user must be able to copy from a