[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] problems while upgrading postgis
From:       Sandro Santilli <strk () kbt ! io>
Date:       2016-11-10 10:32:26
Message-ID: 20161110103226.GJ5515 () localhost
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]