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