Name

PostGIS_Extensions_Upgrade — Upgrades installed postgis packaged extensions (e.g. postgis_sfcgal, postgis_topology, postgis_sfcgal) to latest installed version. Reports full postgis version and build configuration infos after.

Synopsis

text PostGIS_Extensions_Upgrade();

Description

Upgrades installed postgis packaged extensions to latest installed version. Only extensions you have installed in the database will be upgraded and if they are already at last installed version, they will not be upgraded. Reports full postgis version and build configuration infos after. This is short-hand for doing multiple 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 support separate postgis_raster extension

Examples

SELECT PostGIS_Extensions_Upgrade();
NOTICE:  ALTER EXTENSION postgis_tiger_geocoder UPDATE TO "2.5.0dev";
NOTICE:  ALTER EXTENSION postgis_topology UPDATE TO "2.5.0dev";

							   postgis_extensions_upgrade
----------------------------------------------------------------------------------
POSTGIS="2.5.0dev r15966" [EXTENSION] PGSQL="100"
GEOS="3.7.0dev-CAPI-1.11.0 8fe2ce6" SFCGAL="1.3.1"
PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15"
LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" TOPOLOGY RASTER
(1 row)

See Also

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