Hi strk, I've just tried but it complains that "ERROR: type "raster" does not exist"
Thanks for helping Paolo -- Paolo Importuni Software Analyst and Developer Modena, Italy 2016-11-09 11:12 GMT+01:00 Sandro Santilli <s...@kbt.io>: > On Wed, Nov 09, 2016 at 09:45:59AM +0100, Paolo Importuni wrote: > > > I am trying to migrate my postgres/postgis instance from 2.0 to 2.2.2 > > The new postgis.so library is in the right place and I found the right > > migration script postgis-2.0.0--2.2.2.sql. > > > > I successfully upgraded three db instances by using the "ALTER EXTENSION > > postgis UPDATE TO '2.2.2';" command, but it failed on one instance. > > > > As far as I see, the problem might be that the postgis extension wasn't > > created using the "CREATE EXTENSION POSTGIS" script, but maybe by some > > other methods. > > > > If I try to create the extension, it fails saying "ERROR: type "spheroid" > > already exists"; if I try to upgrade it fails, saying that the extension > > postgis does not exist. > > > > If I create a new db instance, create a new extension and then upgrade it > > to postgis 2.2. everything works fine. > > Is a there a way to sort it out? > > To turn your non-extension install to an extension one, try this: > > CREATE EXTENSION POSTGIS VERSION '2.0.0' FROM 'unpackaged'; > > --strk; > > () Free GIS & Flash consultant/developer > /\ https://strk.kbt.io/services.html >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
