Skip to content

Instantly share code, notes, and snippets.

@dincosman

dincosman/upgrade_postgis.sh

Last active June 24, 2024 11:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dincosman/9bd7c8aaf909829094536cc3754ede8f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dincosman/9bd7c8aaf909829094536cc3754ede8f to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade POSTGIS version
Raw
upgrade_postgis.sh
[root@posvt01 postgres16]# yum install ./libdeflate-1.9-3.el8.x86_64.rpm ./re2-20190801-1.el8.x86_64.rpm ./libkml-1.3.0-24.el8.x86_64.rpm \
./geos312-3.12.1-1PGDG.rhel8.x86_64.rpm ./libgeotiff17-1.7.1-6PGDG.rhel8.x86_64.rpm ./libgeotiff17-devel-1.7.1-6PGDG.rhel8.x86_64.rpm \
./proj94-9.4.0-1PGDG.rhel8.x86_64.rpm ./libspatialite50-5.1.0-5PGDG.rhel8.x86_64.rpm ./libspatialite50-devel-5.1.0-5PGDG.rhel8.x86_64.rpm \
./uriparser-0.9.7-1.el8.x86_64.rpm ./postgis34_14-3.4.2-3PGDG.rhel8.x86_64.rpm ./gdal38-libs-3.8.5-3PGDG.rhel8.x86_64.rpm \
./libqhull_r-2015.2-5.el8.x86_64.rpm ./libarrow-8.0.1-2.el8.x86_64.rpm ./armadillo-12.6.6-1.el8.x86_64.rpm --allowerasing
Dependencies resolved.
=========================================================================================================================================
Package Architecture Version Repository Size
=========================================================================================================================================
Installing:
gdal38-libs x86_64 3.8.5-3PGDG.rhel8 @commandline 9.3 M
geos312 x86_64 3.12.1-1PGDG.rhel8 @commandline 1.2 M
libarrow x86_64 8.0.1-2.el8 @commandline 4.7 M
libdeflate x86_64 1.9-3.el8 @commandline 54 k
libgeotiff17 x86_64 1.7.1-6PGDG.rhel8 @commandline 126 k
libgeotiff17-devel x86_64 1.7.1-6PGDG.rhel8 @commandline 33 k
libkml x86_64 1.3.0-24.el8 @commandline 386 k
libqhull_r x86_64 2015.2-5.el8 @commandline 170 k
proj94 x86_64 9.4.0-1PGDG.rhel8 @commandline 2.9 M
re2 x86_64 20190801-1.el8 @commandline 192 k
uriparser x86_64 0.9.7-1.el8 @commandline 71 k
Upgrading:
armadillo x86_64 12.6.6-1.el8 @commandline 42 k
libspatialite50 x86_64 5.1.0-5PGDG.rhel8 @commandline 3.3 M
libspatialite50-devel x86_64 5.1.0-5PGDG.rhel8 @commandline 102 k
postgis32_14 x86_64 3.4.2-3PGDG.rhel8 @commandline 4.0 M
Removing dependent packages:
gdal34-libs x86_64 3.4.3-2.rhel8 @@commandline 28 M
Transaction Summary
=========================================================================================================================================
Install 11 Packages
Upgrade 4 Packages
Remove 1 Package
Total size: 27 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : proj94-9.4.0-1PGDG.rhel8.x86_64 1/20
Running scriptlet: proj94-9.4.0-1PGDG.rhel8.x86_64 1/20
Installing : geos312-3.12.1-1PGDG.rhel8.x86_64 2/20
Running scriptlet: geos312-3.12.1-1PGDG.rhel8.x86_64 2/20
Upgrading : libspatialite50-5.1.0-5PGDG.rhel8.x86_64 3/20
Running scriptlet: libspatialite50-5.1.0-5PGDG.rhel8.x86_64 3/20
Installing : libgeotiff17-1.7.1-6PGDG.rhel8.x86_64 4/20
Running scriptlet: libgeotiff17-1.7.1-6PGDG.rhel8.x86_64 4/20
Installing : libgeotiff17-devel-1.7.1-6PGDG.rhel8.x86_64 5/20
Upgrading : libspatialite50-devel-5.1.0-5PGDG.rhel8.x86_64 6/20
Running scriptlet: libspatialite50-devel-5.1.0-5PGDG.rhel8.x86_64 6/20
Upgrading : armadillo-12.6.6-1.el8.x86_64 7/20
Installing : libqhull_r-2015.2-5.el8.x86_64 8/20
Running scriptlet: libqhull_r-2015.2-5.el8.x86_64 8/20
Installing : uriparser-0.9.7-1.el8.x86_64 9/20
Installing : libkml-1.3.0-24.el8.x86_64 10/20
Installing : re2-20190801-1.el8.x86_64 11/20
Installing : libarrow-8.0.1-2.el8.x86_64 12/20
Installing : libdeflate-1.9-3.el8.x86_64 13/20
Installing : gdal38-libs-3.8.5-3PGDG.rhel8.x86_64 14/20
Upgrading : postgis34_14-3.4.2-3PGDG.rhel8.x86_64 15/20
Cleanup : postgis32_14-3.2.7-1.rhel8.x86_64 16/20
Erasing : gdal34-libs-3.4.3-2.rhel8.x86_64 17/20
Running scriptlet: gdal34-libs-3.4.3-2.rhel8.x86_64 17/20
Cleanup : libspatialite50-devel-5.0.1-4.rhel8.x86_64 18/20
Running scriptlet: libspatialite50-devel-5.0.1-4.rhel8.x86_64 18/20
Cleanup : libspatialite50-5.0.1-4.rhel8.x86_64 19/20
Running scriptlet: libspatialite50-5.0.1-4.rhel8.x86_64 19/20
Cleanup : armadillo-10.8.2-1.el8.x86_64 20/20
Running scriptlet: armadillo-10.8.2-1.el8.x86_64 20/20
Verifying : libdeflate-1.9-3.el8.x86_64 1/20
Verifying : re2-20190801-1.el8.x86_64 2/20
Verifying : libkml-1.3.0-24.el8.x86_64 3/20
Verifying : geos312-3.12.1-1PGDG.rhel8.x86_64 4/20
Verifying : libgeotiff17-1.7.1-6PGDG.rhel8.x86_64 5/20
Verifying : libgeotiff17-devel-1.7.1-6PGDG.rhel8.x86_64 6/20
Verifying : proj94-9.4.0-1PGDG.rhel8.x86_64 7/20
Verifying : uriparser-0.9.7-1.el8.x86_64 8/20
Verifying : gdal38-libs-3.8.5-3PGDG.rhel8.x86_64 9/20
Verifying : libqhull_r-2015.2-5.el8.x86_64 10/20
Verifying : libarrow-8.0.1-2.el8.x86_64 11/20
Verifying : libspatialite50-5.1.0-5PGDG.rhel8.x86_64 12/20
Verifying : libspatialite50-5.0.1-4.rhel8.x86_64 13/20
Verifying : libspatialite50-devel-5.1.0-5PGDG.rhel8.x86_64 14/20
Verifying : libspatialite50-devel-5.0.1-4.rhel8.x86_64 15/20
Verifying : postgis32_14-3.4.2-3PGDG.rhel8.x86_64 16/20
Verifying : postgis32_14-3.4.2-1.rhel8.x86_64 17/20
Verifying : armadillo-12.6.6-1.el8.x86_64 18/20
Verifying : armadillo-10.8.2-1.el8.x86_64 19/20
Verifying : gdal34-libs-3.4.3-2.rhel8.x86_64 20/20
Upgraded:
armadillo-12.6.6-1.el8.x86_64 libspatialite50-5.1.0-5PGDG.rhel8.x86_64 libspatialite50-devel-5.1.0-5PGDG.rhel8.x86_64
postgis32_14-3.4.2-3PGDG.rhel8.x86_64
Installed:
gdal38-libs-3.8.5-3PGDG.rhel8.x86_64 geos312-3.12.1-1PGDG.rhel8.x86_64 libarrow-8.0.1-2.el8.x86_64
libdeflate-1.9-3.el8.x86_64 libgeotiff17-1.7.1-6PGDG.rhel8.x86_64 libgeotiff17-devel-1.7.1-6PGDG.rhel8.x86_64
libkml-1.3.0-24.el8.x86_64 libqhull_r-2015.2-5.el8.x86_64 proj94-9.4.0-1PGDG.rhel8.x86_64
re2-20190801-1.el8.x86_64 uriparser-0.9.7-1.el8.x86_64
Removed:
gdal34-libs-3.4.3-2.rhel8.x86_64
postgres=# select postgis.postgis_full_version();
postgis_full_version
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------
POSTGIS="3.4.2 c19ce56" [EXTENSION] PGSQL="140" GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.
org USER_WRITABLE_DIRECTORY=/var/lib/pgsql/.local/share/proj DATABASE_PATH=/usr/proj94/share/proj/proj.db" LIBXML="2.9.7" LIBJSON="0.13.1
" LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)" (core procs from "3.2.7 32dc0cc" need upgrade)
postgres=# SELECT postgis.PostGIS_Extensions_Upgrade();
NOTICE: Updating extension postgis 3.4.2
postgis_extensions_upgrade
------------------------------------------------------------------------------------
Upgrade to version 3.4.2 completed, run SELECT postgis_full_version(); for details
(1 row)
postgres=# select postgis.postgis_full_version();
postgis_full_version
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------
POSTGIS="3.4.2 c19ce56" [EXTENSION] PGSQL="140" GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.
org USER_WRITABLE_DIRECTORY=/var/lib/pgsql/.local/share/proj DATABASE_PATH=/usr/proj94/share/proj/proj.db" LIBXML="2.9.7" LIBJSON="0.13.1
" LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)"
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment