[postgis-users] postgresql upgrade from 8.4 to 9.1

[Martin Landa]

Hi all,

I am trying to upgrade my PG cluster from 8.4 (which contains some
PostGIS DBs) to 9.1.

Performing:

pg_dropcluster --stop 9.1
pg_upgradecluster 8.4 main

gives me

NOTICE:  schema "topology" does not exist
NOTICE:  schema "topology" does not exist
NOTICE:  schema "topology" does not exist
NOTICE:  schema "topology" does not exist
NOTICE:  schema "topology" does not exist
ERROR:  could not find function "BOX2DFLOAT4_in" in file
"/usr/lib/postgresql/9.1/lib/postgis-2.0.so"
ERROR:  function public.box2d_in(cstring) does not exist
ERROR:  could not find function "BOX2DFLOAT4_out" in file
"/usr/lib/postgresql/9.1/lib/postgis-2.0.so"
ERROR:  function public.box2d_out(box2d) does not exist
ERROR:  function box2d_in(cstring) does not exist
ERROR:  could not find function "BOX3D_extent_out" in file
"/usr/lib/postgresql/9.1/lib/postgis-2.0.so"
ERROR:  function public.box3d_extent_out(box3d_extent) does not exist
ERROR:  function box3d_extent_out(box3d_extent) does not exist
ERROR:  could not find function "geography_typmod_out" in file
"/usr/lib/postgresql/9.1/lib/postgis-2.0.so"
ERROR:  function public.geography_typmod_out(integer) does not exist
ERROR:  function geography_typmod_out(integer) does not exist
ERROR:  could not find function "LWGEOM_analyze" in file
"/usr/lib/postgresql/9.1/lib/postgis-2.0.so"
ERROR:  function public.geometry_analyze(internal) does not exist

I have installed same PostGIS version (2.0.3) in the both versions of
PostgreSQL.

Any ideas what could be wrong? Thanks in advance! Martin

-- 
Martin Landa <landa.martin gmail.com> * http://geo.fsv.cvut.cz/~landa