Re: [Zope] SQL Database Connections
Am Freitag, den 20.05.2005, 18:28 +0200 schrieb Andreas Jung: > > --On Freitag, 20. Mai 2005 9:18 Uhr -0700 Jonathan Daugherty > <[EMAIL PROTECTED]> wrote: > > ># Depends on the underlaying DAso 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... ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SQL Database Connections
--On Freitag, 20. Mai 2005 9:18 Uhr -0700 Jonathan Daugherty <[EMAIL PROTECTED]> wrote: # Depends on the underlaying DAso 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 pgpWEdvNFsUxh.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SQL Database Connections
Jonathan Daugherty wrote: > # Depends on the underlaying DAso 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 <[EMAIL PROTECTED]> * 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 ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SQL Database Connections
# Depends on the underlaying DAso 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 ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SQL Database Connections
--On Freitag, 20. Mai 2005 9:05 Uhr -0700 Jonathan Daugherty <[EMAIL PROTECTED]> 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 DAso which one are you using? In general a DA should reconnect automatically. -aj pgpmRjFbWVs7B.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] SQL Database Connections
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 ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
