Rafael Laboissiere wrote: > * Jerome Warnier <[EMAIL PROTECTED]> [2008-09-27 18:23]: > > >> Package: webcalendar >> Version: 1.2~b1-2 >> Severity: normal >> >> I tried to upgrade my WebCalendar (running on PostgreSQL) with this >> experimental package on Etch. >> Sadly, the package gets upgraded, but not the DB. >> Trying to upgrade the DB manually with the script >> /usr/share/webcalendar/www/install/sql/upgrade-postgres.sql fails with >> errors, I guess because WebCalendar 1.2 does not support PostgreSQL 7.x >> (I use 7.4). >> >> This is just a request to tighten dependencies to a specific minimal >> version of PostgreSQL, or at least adding something in the README. >> > > Thanks for your bug report. I do remember having tested webcalendar with > PostgreSQL 7.x with database upgrade, so I take your word as true. > WebCalendar does not depend directly on PostgreSQL, but through php*-pgsql, > so it will be tricky to achieve this. BTW, there is something I do not > understand in your setup: > > >> Versions of packages webcalendar depends on: >> [snip] >> ii php4-pgsql 6:4.4.4-8+etch6 PostgreSQL module for php4 >> [snip] >> ii php5-pgsql 5.2.0-8+etch11 PostgreSQL module for php5 >> > > According to packages.d.o [1] [2], the versions above depend on libpq4 >= > 8.1.4. How does it comes that you are using WebCalendar with PostgreSQL > 7.4? Which version of php*-pgsql are you using? > Etch ships with both PostgreSQL 7.4 and 8.1. We started running Sarge and developed in-house some other applications using PHP (4.x) and PostgreSQL (7.x at that time). Then, we upgraded to Etch, and installed WebCalendar (on Apache 1.x + PHP 4.x). And some time ago, we went to PHP5.
Finally, we decided to upgrade our WebCalendar. Debian also rules because of its clean upgrade path. To answer to your question strictly speaking, as Etch ships with both versions of PG and newest clients are backward-compatible with older servers, the PHP module was built with the 8.1 client but allows to connect to 7.4. > [1] http://packages.debian.org/etch/php4-pgsql > [2] http://packages.debian.org/etch/php5-pgsql > > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
