[postgis-users] CentOS : postgis compatibility with postgresql.

postgo at khiplus.fr postgo at khiplus.fr
Tue Sep 7 06:29:55 PDT 2021


Hi,

For some tests, i am searching a way to install postgis with a 
postgresql 11 on an old centos (7.5).
Is there some list about compatibility of postgis and postgresql 11 ? i 
can see that : 
https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
I found it on the 7.5 :  postgresql-9.2.23/24 (no postgis available)
But i need to upgrade in a 11's version.

Then i made a new repository with postgresql 11 : 
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7.5-x86_64/

To install by example postgresql11 (11.13) isn't a problem, but when i 
want to install postgis 2.5 there's dependency's problems :

# yum install postgis25_11.x86_64
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
  * base: centos-mirror.usessionbuddy.com
  * extras: centos-mirror.usessionbuddy.com
  * updates: centos-mirror.usessionbuddy.com
Resolving Dependencies
--> Running transaction check
---> Package postgis25_11.x86_64 0:2.5.5-5.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: gdal32-libs >= 3.2.3 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: xerces-c for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: postgresql11-contrib for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: postgresql11 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: 
libprotobuf-c.so.1(LIBPROTOBUF_C_1.0.0)(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: json-c for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: hdf5 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libtiff.so.5()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libprotobuf-c.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libjson-c.so.2()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgdal.so.28()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Running transaction check
---> Package json-c.x86_64 0:0.11-4.el7_0 will be installed
---> Package libtiff.x86_64 0:4.0.3-35.el7 will be installed
--> Processing Dependency: libjpeg.so.62(LIBJPEG_6.2)(64bit) for 
package: libtiff-4.0.3-35.el7.x86_64
--> Processing Dependency: libjpeg.so.62()(64bit) for package: 
libtiff-4.0.3-35.el7.x86_64
--> Processing Dependency: libjbig.so.2.0()(64bit) for package: 
libtiff-4.0.3-35.el7.x86_64
---> Package postgis25_11.x86_64 0:2.5.5-5.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: gdal32-libs >= 3.2.3 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: hdf5 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgdal.so.28()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
---> Package postgresql11.x86_64 0:11.13-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql11-libs(x86-64) = 11.13-1PGDG.rhel7 
for package: postgresql11-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: systemd-sysv for package: 
postgresql11-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: libicu for package: 
postgresql11-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: 
postgresql11-11.13-1PGDG.rhel7.x86_64
---> Package postgresql11-contrib.x86_64 0:11.13-1PGDG.rhel7 will be 
installed
--> Processing Dependency: postgresql11-server(x86-64) = 
11.13-1PGDG.rhel7 for package: 
postgresql11-contrib-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for 
package: postgresql11-contrib-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for 
package: postgresql11-contrib-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for 
package: postgresql11-contrib-11.13-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1()(64bit) for package: 
postgresql11-contrib-11.13-1PGDG.rhel7.x86_64
---> Package protobuf-c.x86_64 0:1.0.2-3.el7 will be installed
---> Package xerces-c.x86_64 0:3.1.1-10.el7_7 will be installed
--> Running transaction check
---> Package jbigkit-libs.x86_64 0:2.0-11.el7 will be installed
---> Package libicu.x86_64 0:50.2-4.el7_7 will be installed
---> Package libjpeg-turbo.x86_64 0:1.2.90-8.el7 will be installed
---> Package libxslt.x86_64 0:1.1.28-6.el7 will be installed
---> Package postgis25_11.x86_64 0:2.5.5-5.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: gdal32-libs >= 3.2.3 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: hdf5 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgdal.so.28()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
---> Package postgresql11-libs.x86_64 0:11.13-1PGDG.rhel7 will be 
installed
---> Package postgresql11-server.x86_64 0:11.13-1PGDG.rhel7 will be 
installed
---> Package systemd-sysv.x86_64 0:219-78.el7_9.3 will be installed
--> Processing Dependency: systemd = 219-78.el7_9.3 for package: 
systemd-sysv-219-78.el7_9.3.x86_64
--> Running transaction check
---> Package postgis25_11.x86_64 0:2.5.5-5.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: gdal32-libs >= 3.2.3 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: hdf5 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgdal.so.28()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
---> Package systemd.x86_64 0:219-57.el7 will be updated
---> Package systemd.x86_64 0:219-78.el7_9.3 will be an update
--> Processing Dependency: systemd-libs = 219-78.el7_9.3 for package: 
systemd-219-78.el7_9.3.x86_64
--> Processing Dependency: libcryptsetup.so.12(CRYPTSETUP_2.0)(64bit) 
for package: systemd-219-78.el7_9.3.x86_64
--> Processing Dependency: libcryptsetup.so.12()(64bit) for package: 
systemd-219-78.el7_9.3.x86_64
--> Running transaction check
---> Package cryptsetup-libs.x86_64 0:1.7.4-4.el7 will be updated
---> Package cryptsetup-libs.x86_64 0:2.0.3-6.el7 will be an update
---> Package postgis25_11.x86_64 0:2.5.5-5.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: gdal32-libs >= 3.2.3 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: hdf5 for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libgdal.so.28()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: 
postgis25_11-2.5.5-5.rhel7.x86_64
---> Package systemd-libs.x86_64 0:219-57.el7 will be updated
---> Package systemd-libs.x86_64 0:219-78.el7_9.3 will be an update
--> Finished Dependency Resolution
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: hdf5
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: libproj.so.19()(64bit)
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: libSFCGAL.so.1()(64bit)
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: gdal32-libs >= 3.2.3
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: libgeos_c.so.1()(64bit)
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: SFCGAL
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: geos39 >= 3.9.1
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: proj72 >= 7.2.1
Error: Package: postgis25_11-2.5.5-5.rhel7.x86_64 (postgresql)
            Requires: libgdal.so.28()(64bit)
  You could try using --skip-broken to work around the problem
  You could try running: rpm -Va --nofiles --nodigest


Do you know a solution to install postgis with postgresql 11 ?

Is it necessary to install with sources (./configure; make; make install 
?)


Best regards,


More information about the postgis-users mailing list