Name

PostGIS_Extensions_Upgrade — Packages and upgrades postgis extensions (e.g. postgis_sfcgal, postgis_topology, postgis_sfcgal) to latest available version.

Synopsis

text PostGIS_Extensions_Upgrade();

Description

Packages and upgrades postgis extensions to latest version. Only extensions you have installed in the database will be packaged and upgraded if needed. Reports full postgis version and build configuration infos after. This is short-hand for doing multiple CREATE EXTENSION .. FROM unpackaged and ALTER EXTENSION .. UPDATE for each postgis extension. Currently only tries to upgrade extensions postgis, postgis_raster, postgis_sfcgal, postgis_topology, and postgis_tiger_geocoder.

Availability: 2.5.0

[Note]

Changed: 3.0.0 to repackage loose extensions and support postgis_raster.

Examples

SELECT PostGIS_Extensions_Upgrade();
NOTICE:  Packaging extension postgis
NOTICE:  Packaging extension postgis_raster
NOTICE:  Packaging extension postgis_sfcgal
NOTICE:  Extension postgis_topology is not available or not packagable for some reason
NOTICE:  Extension postgis_tiger_geocoder is not available or not packagable for some reason

							   postgis_extensions_upgrade
----------------------------------------------------------------------------------
POSTGIS="3.0.0dev r16878" [EXTENSION] PGSQL="96"
GEOS="3.8.0dev-CAPI-1.11.0 a67b6f86" SFCGAL="1.3.5" PROJ="Rel. 4.9.3,
15 August 2016" GDAL="GDAL 2.3.0dev, released 2017/99/99"
LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" TOPOLOGY
[UNPACKAGED!] RASTER
(1 row)

See Also

Section 2.11, “Upgrading”, PostGIS_GEOS_Version, PostGIS_Lib_Version, PostGIS_LibXML_Version, PostGIS_PROJ_Version, PostGIS_Version