[postgis-users] problems while upgrading postgis

[Sandro Santilli]

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;