On Wed, Nov 09, 2016 at 09:18:06PM +0100, Paolo Importuni wrote: > The soft upgrade works "ALTER EXTENSION postgis UPDATE TO '2.2.2';" works > only if the db instance was spatially enabled by running the script "CREATE > EXTENSION POSTGIS" > In case it wasn´t and as strk suggested, run the following steps: > > CREATE EXTENSION POSTGIS VERSION '2.0.0' FROM 'unpackaged'; > sudo -u postgres psql -d <yrdb> -f rtpostgis.sql > (in /usr/share/postgresql/9.1/contrib/postig-2.0/ on my instance)
To be clear: the second step (sourcing rtpostgis.sql) is actually only needed IFF the first step fails due to raster not being loaded in <yrdb>, and needs to be performed *before* the CREATE EXTENSION .. FROM 'unpackaged' line. --strk; _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
