Sorry this is an extremely old thread, but I finally got around to
tracking down the problem.. Added these lines to postgres.conf and
poof, problem gone..
tcp_keepalives_idle = 60# TCP_KEEPIDLE, in seconds;
tcp_keepalives_interval = 10# TCP_KEEPINTVL, in seconds;
tcp_k
Maybe that's it.. It's definitely some sort of SSL thing since it
didn't start happening until I enabled SSL. I guess I'll just have to
close pgAdmin when I'm not using it..
On Sat, Oct 30, 2010 at 12:57 AM, Basil Bourque wrote:
>
> On Oct 29, 2010, at 15:36, Mike Christensen wrote:
>
>> I have
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 e
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
