Re: pgadmin and broken connections

On Tue, Jul 12, 2011 at 5:45 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
>>> Booo.   I spoke too soon.  While reconnecting the query window works
>>> perfectly, reconnecting the object navigator does not.  I just get
>>> "refreshing server ______ ... failed".
>>
>> I'm unable to recreate that :-(
>
> Well, it's happening pretty consistently here:
>
> 1) create an SSH tunnel to a PG server
> 2) Connect to pg server and open several query windows
> 3) close SSH tunnel
> 4) reopen ssh tunnel
> 5) try to access object browser
> 6) get "refreshing ... failed", or crash
>
> I think I can reproduce the above pattern 100% of the time.  Note that
> pgadmin stays up until I make the mistake of clicking on the object browser.

For the benefit of the list, I just re-wrote much of the code that
handles this, and posted a proposed patch to the hackers list:
http://archives.postgresql.org/pgadmin-hackers/2011-07/msg00267.php

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company