Opened 5 years ago
Closed 5 years ago
#4432 closed defect (duplicate)
Unable to upgrade procedures from 11 to 12 flavour
| Reported by: | komzpa | Owned by: | strk |
|---|---|---|---|
| Priority: | blocker | Milestone: | PostGIS 3.0.0 |
| Component: | build | Version: | 2.4.x |
| Keywords: | Cc: |
Description
gis=# select postgis_extensions_upgrade(); psql: NOTICE: Extension postgis_topology is not available or not packagable for some reason psql: NOTICE: Extension postgis_tiger_geocoder is not available or not packagable for some reason
postgis_extensions_upgrade
Upgrade completed, run SELECT postgis_full_version(); for details
(1 row)
gis=# select postgis_full_version();
postgis_full_version
POSTGIS="3.0.0alpha2 r17458" [EXTENSION] PGSQL="110" (procs need upgrade for use with PostgreSQL "120") GEOS="3.7.1-CAPI-1.11.1 27a5e771" SFCGAL="1.3.6" PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.4.0, released 2018/12/14" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.4.3 (Internal)" RASTER
(1 row)
Change History (4)
comment:1 by , 5 years ago
comment:2 by , 5 years ago
| Component: | postgis → build/upgrade/install |
|---|---|
| Owner: | changed from to |
comment:3 by , 5 years ago
Did you have postgis_topology and postgis_tiger_geocoder installed before hand? I would think those errors would only happen if you had postgis_topology and postgis_tiger_geocoder installed and for some reason you didn't have them available in your new version.
next dance works:
gis=# alter extension postgis update TO "3.0.0alpha2next" ; ALTER EXTENSION gis=# alter extension postgis update TO "3.0.0alpha2" ; ALTER EXTENSION gis=# select postgis_full_version(); postgis_full_version -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- POSTGIS="3.0.0alpha2 r17458" [EXTENSION] PGSQL="120" GEOS="3.7.1-CAPI-1.11.1 27a5e771" SFCGAL="1.3.6" PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.4.0, released 2018/12/14" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.4.3 (Internal)" RASTER (1 row)