[postgis-devel] Pg13 upgrade issues?

[Regina Obe]

Yap and I think strk created one his strk ingenious idea fixes to fix that.  In a pull request https://git.osgeo.org/gitea/postgis/postgis/pulls/45

 

 

 

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Paul Ramsey
Sent: Thursday, September 10, 2020 3:16 PM
To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
Subject: Re: [postgis-devel] Pg13 upgrade issues?

 



On Thu, Sep 10, 2020 at 11:14 AM Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> > wrote:
> I suspect you installed 3.1 first and then 2.5 after.  So 2.5 is considered the default.

 

OK, fixing up that, here's what actually happens (still bad)

 

postgis25=# alter extension postgis update to '3.1.0dev';
WARNING:  unpackaging raster
WARNING:  PostGIS Raster functionality has been unpackaged
HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;
ALTER EXTENSION
postgis25=# SELECT postgis_extensions_upgrade();
NOTICE:  Updating extension postgis 3.1.0dev
NOTICE:  Packaging extension postgis_raster
ERROR:  CREATE EXTENSION ... FROM is no longer supported
LINE 1: CREATE EXTENSION postgis_raster FROM unpackaged SCHEMA publi...
                                        ^
QUERY:  CREATE EXTENSION postgis_raster FROM unpackaged SCHEMA public;
CONTEXT:  PL/pgSQL function postgis_extensions_upgrade() line 57 at EXECUTE
postgis25=# 

 

So, as expected, the raster repackaging step fails because "from unpackaged" has been removed.

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20200910/8b063355/attachment.html>