Postgres Pro
Downloads
Home   >   mailing lists

Thread: Timing out connections?

Timing out connections?

From
Peter Fein
Date:
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

Re: Timing out connections?

From
"A. Kretschmer"
Date:
am  18.08.2005, um 12:36:26 -0500 mailte Peter Fein folgendes:
> 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 &

I know a better solution:

Use on the server screen. If the connection going dow and you have later
a new connection, then you can reattach to the old screen-session.
Screen is a very nice tool ;-)


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: Timing out connections?

From
Tino Wildenhain
Date:
Am Donnerstag, den 18.08.2005, 12:36 -0500 schrieb Peter Fein:
> 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.

You might try openvpn (anyway for WiFi connections - since WEP isnt
really enough) as it is fully transparent (you dont need to start up
the tunneling per connection as of ssh) and it maintains connection keep
alive and stuff.

Re: Timing out connections?

From
Len Walter
Date:
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