Re: Timing out connections?

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

Len

On 8/19/05, Peter Fein <pfein@pobox.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@pobox.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.walter@gmail.com http://crookedtimbre.net