[postgis-users] Postgis Update from 2.4 to 3.0

[Zwettler Markus (OIZ)]

Is this the fix mentioned?
<quote>
The same procedure applies to raster, topology and sfcgal extensions, with upgrade files named rtpostgis_upgrade.sql, topology_upgrade.sql and sfcgal_upgrade.sql respectively.
</quote>
https://postgis.net/docs/manual-3.0/postgis_installation.html#soft_upgrade



So "alter extension postgis update" is working rather well. Ok?



Thanks,
Markus




Von: postgis-users <postgis-users-bounces at lists.osgeo.org> Im Auftrag von William Kyngesburye
Gesendet: Dienstag, 26. Mai 2020 14:46
An: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Betreff: Re: [postgis-users] Postgis Update from 2.4 to 3.0

There is one key step that tripped me up - the raster part of PostGIS was split into its own extension.  After updating the extensions within Postgres, the new postgis-raster extension will be "updated" as an "unpackaged" extension - it won't be visible but will be there and usable.  It could cause trouble later if you upgrade Postgis again or Postgres (I had a couple missing raster functions that caused a Postgres upgrade failure).

To fix this see the manual, there's a note at the bottom of the  soft upgrade with extensions section.
-----
William Kyngesburye
<kyngchaos at kyngchaos.com<mailto:kyngchaos at kyngchaos.com>>
<http://www.kyngchaos.com>


Don't Panic


On May 26, 2020, at 3:30 AM, Zwettler Markus (OIZ) <Markus.Zwettler at zuerich.ch<mailto:Markus.Zwettler at zuerich.ch>> wrote:

Hi,


We used and had postgis24 installed:

postgis24_96-client-2.4.8-5.rhel7.x86_64
postgis24_96-2.4.8-5.rhel7.x86_64
pgrouting_96-2.6.2-1.rhel7.x86_64
ogr_fdw96-1.0.8-1.rhel7.x86_64


After an Linux update postgis30 packages were installed:

postgis30_96-client-3.0.1-5.rhel7.x86_64
postgis30_96-3.0.1-5.rhel7.x86_64
pgrouting_96-3.0.0-rc1_2.rhel7.x86_64
ogr_fdw96-1.0.9-1.rhel7.x86_64


Afaik, we must do an "alter extension postgis update" now.


QUESTION: Is an update to postgis30 that easy? Could there be any problems?


Thanks,
Markus


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200527/fab91ebd/attachment.html>