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

Re: reconnecting to DB after connection break

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Cc: Chuck McDevitt <cmcdevitt(at)greenplum(dot)com>, Julius Tuskenis <julius(dot)tuskenis(at)gmail(dot)com>
Subject: Re: reconnecting to DB after connection break
Date: 2009-08-21 20:45:36
Message-ID: 200908212245.36789.guillaume@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le vendredi 21 août 2009 à 22:05:42, Chuck McDevitt a écrit :
> > -----Original Message-----
> > From: pgadmin-hackers-owner(at)postgresql(dot)org [mailto:pgadmin-hackers-
> > owner(at)postgresql(dot)org] On Behalf Of Julius Tuskenis
> > Sent: Friday, August 21, 2009 3:16 AM
> > To: pgadmin-hackers(at)postgresql(dot)org
> > Subject: [pgadmin-hackers] reconnecting to DB after connection break
> >
> > Hello,
> >
> > I'm thinking of changing pgAdmin so it would try to reconnect after its
> > connection to server breaks. Is that ok with you? Maybe theres someone
> > already dealing with the problem.
> >
> > I think I could change pgConn::ExecuteVoid, pgConn::ExecuteScalar and
> > pgConn::ExecuteSet methods so on connection to DB error there would be
> > an attempt to reconnect. If someone knows a better solution - please,
> > share it. :)
> >
> > I'm new here so maybe someone would advice what "pitfalls" to avoid.
> >
> > --
> > Julius Tuskenis
>
> Sounds like a good idea.  The one pitfall I see is that any temporary
> tables the session had disappear when you disconnect and reconnect, but I
> don't think there is anything to be done about that.

You're right. There's also no way to continue the previous transaction. 
Anyways, lots of people are asking for this feature.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

In response to

pgadmin-hackers by date

Next:From: Andy ShellamDate: 2009-08-21 22:28:55
Subject: Re: Background color in query tool
Previous:From: Chuck McDevittDate: 2009-08-21 20:05:42
Subject: Re: reconnecting to DB after connection break

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