There are tcp_keepalives on the server side of postgresql
The problem was that debian waits 2 hours before starting the keepalives
(7200 s).
Also, the connection would only be kept alive for 9*75 s, which is 11 min.
So i changed the tcp_keepalives_idle to 120 (keepalives start after 2 min)
and th
I looked at this problem once again with a colleage and came to the
conclusion that the firewall is timing out the connection.
Some other client software packages, like SSH for example, have a mechanism
to manage this problem:
"NAT firewalls like to time out idle sessions to keep their state tabl
the point i was trying to make is that pgAdmin seems to have the possibility
to restore the connection, since opening a new sql window does the trick.
"All you'd need to do" would be to invoke this behavior when it is
necessary, without opening a new window.
cheers,
WBL
On Mon, Apr 7, 2008 at 6:
Hi,
We also have issues with connections ending abrubtly. Not only with pgAdmin
by the way.
We're at the end of a DSL line, and the connection usually has a lot of
hiccups.
After one of those hiccups, you have to wait for at least 30 seconds to find
out what happened, after which you get a correct
On Mon, Mar 31, 2008 at 9:59 PM, Maciek Sakrejda <[EMAIL PROTECTED]> wrote:
> I was able to reproduce this on 1.8.2, building from source (and I get
> the hang this time, not the segfault). A small dialog box comes up to
> tell me something (possibly that it's about to segfault), but it's not
>
admin:
Xlib: unexpected async reply (sequence 0xf810)!
--
Maciek Sakrejda
Truviso, Inc.
http://www.truviso.com
-Original Message-
From: Maciek Sakrejda <[EMAIL PROTECTED]>
To: Dave Page <[EMAIL PROTECTED]>
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAd
dmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin hang on connection drop/reconnect
Date: Thu, 27 Mar 2008 16:07:58 +
On Mon, Mar 24, 2008 at 5:04 PM, Maciek Sakrejda <[EMAIL PROTECTED]> wrote:
> pgAdmin hangs when connection drops while trying to execute a query
>
> Steps
On Mon, Mar 24, 2008 at 5:04 PM, Maciek Sakrejda <[EMAIL PROTECTED]> wrote:
> pgAdmin hangs when connection drops while trying to execute a query
>
> Steps to reproduce:
>
> 1. Open SQL query pane
> 2. Type "SELECT pg_sleep(10);"
> 3. Shut down postgres in less than ten seconds (the query in pg
pgAdmin hangs when connection drops while trying to execute a query
Steps to reproduce:
1. Open SQL query pane
2. Type "SELECT pg_sleep(10);"
3. Shut down postgres in less than ten seconds (the query in pgAdmin
will error out)
4. Start postgres
5. Re-run the query
Result: pgAdmin will hang.
Exp
