TheCubicWebBook #153980 bugs in migration from postgres8.1 to postgres8.3 [open]

When migrating from etch to lenny, we have to migration postgres from 8.1 to 8.3

Using

pg_dropcluster 8.3 main # this will remove all databases managed by 8.3
pg_upgradecluster -v 8.3 8.1 main

gives a bunch of errors which apparently we can safely ignore.

There are some missing postgres packages (dependencies ?) - I installed that after the upgradecluster :

apt-get -uVf install postgresql-contrib-8.3 postgresql-plpython-8.3

For me python-indexer was not working (python2.4 -> python2.5) so I had to :

apt-get -uVf --reinstall install python-indexer

For each database had to

postgres@:~$ psql databasename
databasename=# CREATE LANGUAGE plpythonu;
CREATE LANGUAGE
databasename=# \q
postgres@:~$ cat /usr/share/cubicweb/cubes/jpl/schema/_regproc.sql.postgres | psql databasename
CREATE FUNCTION
CREATE FUNCTION

Finally the appears table was not migrated, had to recreate it before db-rebuild-fti.

prioritynormal
typebug
done in<not specified>
load0.200
load left0.200
closed by<not specified>