Skip site navigation (1) Skip section navigation (2)

Re: Handling connection loss

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: Handling connection loss
Date: 2011-07-19 09:19:05
Message-ID: 1311067145.2036.24.camel@laptop (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Tue, 2011-07-19 at 09:53 +0100, Dave Page wrote:
> On Mon, Jul 18, 2011 at 9:11 PM, Guillaume Lelarge
> <guillaume(at)lelarge(dot)info> wrote:
> >
> > Did some tests and found something weird. I connect pgadmin to a
> > database, I look into some objects with pgAdmin's browser. Then, I stop
> > PostgreSQL, and start it again. Next object I click on will display a
> > nice "lost connection" message, and another messagebox asking me if I
> > want to reconnect. I click Yes and everything seems good (iow, I have
> > the info I asked). I then click on another object, and it asks me again
> > if I want to reconnect. Weird. I click Yes, and I get reconnected, and I
> > won't be bothered again. I find it weird to have to say Yes two times
> > when the connection was lost only once.
> 
> Was the second object in the same database? Don't forget that we might
> have to restore multiple connections to individual databases, and the
> maintenance DB - and we only test them when we need them.
> 

It was the same one.

> > Moreover, with the SSH tunnel as described by Christophe Chauvet on
> > -support, I don't even have the message box asking me if I want to
> > reconnect.
> 
> I was testing using Josh's SSH tunnel test primarily, so that worked
> well for me. Can you describe the steps to reproduce the issue?
> 

Create an SSH tunnel (for example like this ssh -L 2000:127.0.0.1:5432
myuser(at)my_ip).

Launch PgAdmin, open a connection with server localhost, port 2000. You
should be able to connect to a database. Then, go to your terminal, drop
the tunnel connection, and then reopen the tunnel connection. Go back to
the browser, click on some objects. pgAdmin didn't ask if I want to
reconnect.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


In response to

Responses

pgadmin-hackers by date

Next:From: Jasmin DizdarevicDate: 2011-07-19 09:34:57
Subject: Re: Website
Previous:From: Guillaume LelargeDate: 2011-07-19 09:13:31
Subject: Re: Website

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group