Greetings, I connect to PostgreSQL from Zope and whenever I upgrade postgres on my server, my persistent database connections in Zope fail. I have to log in to the ZMI and reconnect the connection objects manually to restore the connections; is there a way to attempt a reconnection automatically when postgres goes down or is upgraded? -- Jonathan Daugherty http://www.parsed.org
--On Freitag, 20. Mai 2005 9:05 Uhr -0700 Jonathan Daugherty <cygnus@cprogrammer.org> wrote:
Greetings,
I connect to PostgreSQL from Zope and whenever I upgrade postgres on my server, my persistent database connections in Zope fail. I have to log in to the ZMI and reconnect the connection objects manually to restore the connections; is there a way to attempt a reconnection automatically when postgres goes down or is upgraded?
Depends on the underlaying DA....so which one are you using? In general a DA should reconnect automatically. -aj
# Depends on the underlaying DA....so which one are you using? In # general a DA should reconnect automatically. I'm using the zope-psycopgda 1.1.18-1 debian package, debian testing. -- Jonathan Daugherty http://www.parsed.org
Jonathan Daugherty wrote:
# Depends on the underlaying DA....so which one are you using? In # general a DA should reconnect automatically.
I'm using the zope-psycopgda 1.1.18-1 debian package, debian testing.
That version of ZPsycopgDA doesn't auto-reconnect, but it looks like that feature was added back in 1.1.19 http://initd.org/svn/initd/psycopg1/trunk/ChangeLog ------------ 2005-01-13 Federico Di Gregorio <fog@debian.org> * ZPsycopgDA/db.py (DB.query): applied patch from Jonathan Stoneman to automatically try to reconnect *once* on OperationalError. This fix the problem with Zope loosing the connection to the database when PostgreSQL is restarted. ------------ Barry
--On Freitag, 20. Mai 2005 9:18 Uhr -0700 Jonathan Daugherty <cygnus@cprogrammer.org> wrote:
# Depends on the underlaying DA....so which one are you using? In # general a DA should reconnect automatically.
I'm using the zope-psycopgda 1.1.18-1 debian package, debian testing.
Try to upgrade... -aj
Am Freitag, den 20.05.2005, 18:28 +0200 schrieb Andreas Jung:
--On Freitag, 20. Mai 2005 9:18 Uhr -0700 Jonathan Daugherty <cygnus@cprogrammer.org> wrote:
# Depends on the underlaying DA....so which one are you using? In # general a DA should reconnect automatically.
I'm using the zope-psycopgda 1.1.18-1 debian package, debian testing.
Try to upgrade...
Well, afaic this is a problem of the upgrade ;) this "feature" was introduced in the recent version of the psycopgda. Maybe this can be hacked...
participants (4)
-
Andreas Jung -
Barry Pederson -
Jonathan Daugherty -
Tino Wildenhain