Re: Handling connection loss

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