Re: Handling connection loss

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.

> 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?

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

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