On Tue, Sep 09, 2008 at 03:31:00PM +0200, Morten Brekkevold wrote:
On Tue, 9 Sep 2008 13:58:07 +0100 Tim Chown tjc@ecs.soton.ac.uk wrote:
Is there any gotcha to doing a straight aptitude update from a previous version (3.4.1) to the new version on a live system?
There shouldn't be. But make sure to do a "/etc/init.d/apache2 force-reload" after the upgrade, to make sure Apache/mod_python is using the new NAV code.
The upgrade seemed to work fine.
I followed the info about the sql update but got errors:
# psql -f 3.4.2.sql manage nav Password for user nav: BEGIN CREATE RULE CREATE RULE CREATE RULE psql:3.4.2.sql:46: ERROR: syntax error at or near "WHERE" at character 1 psql:3.4.2.sql:46: LINE 1: WHERE key='serviceid' AND value=old.serviceid::text; psql:3.4.2.sql:46: ^ ROLLBACK
We have psql 8.1, but I assumed the patch was required because we did install 3.4.1 from scratch. The comment in the patch file also says "NAV 3.4.1 and 3.4.1 were shipped with a manage.sql..." which I assume should say "NAV 3.4 and 3.4.1".
Is the patch failing because we don't need it, or some other issue? :)
Thanks,