Re: [SQLObject] Auto reconnect with postgres

[Oleg B. <ph...@ph...>]

On Wed, Oct 20, 2010 at 10:47:41AM +0200, Gert Burger wrote:
> SQLObject doesn't seem to reconnect to a postgres DB when its
> connection(s) are lost. Is SO capable of reconnecting?
> 
> I saw a few post related to SO and Mysql but nothing related to PG.
> 
> A grep of the source also shows that only mysqlconnection.py has
> reconnect logic in it.

   MySQL can automagically reconnect by calling connection.ping(True) -
after that if client library notes a connection is lost it tries to
reconnect. Users must understand though that automatic reconnect has its
set of problems; see
http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html for details.

   PostgreSQL's client library doesn't do a reconnect exactly to avoid
these problems. On the other hand having timed out connections in
SQLObject's pool is a problem, I understand. There have to be a way to
remove them from the pool to force SQLObject to open new connections.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.