Re: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue - Mailing list pgsql-general

From Basil Bourque
Subject Re: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue
Date
Msg-id 21491A86-33DD-497F-B106-C74EE6BC3BBD@me.com
Whole thread Raw
In response to pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue  (Mike Christensen <mike@kitchenpc.com>)
Responses Re: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue  (Mike Christensen <mike@kitchenpc.com>)
List pgsql-general
On Oct 29, 2010, at 15:36, Mike Christensen wrote:

> I have a Postgres 9 server running on a server out on the Internet and
> I connect to it with pgAdmin on OS/X over an SSL connection.
>
> I notice if I keep the connection open and idle for maybe an hour or
> so, when I try to run a query it either times out or pgAdmin just
> kinda freezes up and I have to force quit..  Is there some sort of
> idle timeout setting on SSL connections, or maybe it has to
> re-negotiate the connection after a certain amount of idle time and
> it's not doing that right?
>
> Anyone run into this before?  Thanks!

I don't know about pgAdmin or SSL, but I have heard that routers and switches
can have a timeout limit: "the idle time after which an established
connection of any protocol closes".

http://search.gmane.org/?query=router+timeout&group=gmane.comp.lang.inug-4d.tech

--Basil Bourque



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Max tables in a union
Next
From: RP Khare
Date:
Subject: Enable automatic scheduled backups