[postgis-users] CentOS : postgis compatibility with postgresql.
463 views
Skip to first unread message
pos...@khiplus.fr
Sep 7, 2021, 9:39:28 AM9/7/21
to postgi...@lists.osgeo.org
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,
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
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,
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
Regina Obe
Sep 7, 2021, 10:01:47 AM9/7/21
to PostGIS Users Discussion
Those dependencies I believe are included in
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64
as noted in this thread
https://lists.osgeo.org/pipermail/postgis-devel/2021-August/029136.html
So you need to add that as well.
> ---> 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
> ---> 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
> ---> 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
> ---> 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
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64
as noted in this thread
https://lists.osgeo.org/pipermail/postgis-devel/2021-August/029136.html
So you need to add that as well.
> ---> libtiff.x86_64 0:4.0.3-35.el7 will be installed
> ---> 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
> ---> systemd.x86_64 0:219-78.el7_9.3 will be an update
> ---> systemd-libs.x86_64 0:219-78.el7_9.3 will be an update
pos...@khiplus.fr
Sep 7, 2021, 12:34:02 PM9/7/21
to PostGIS Users Discussion
Thanks, it pass.
An other question but it is possible to choose the postgresql version to
install with postgis ?
Regards
Regina Obe
Sep 7, 2021, 12:50:01 PM9/7/21
to PostGIS Users Discussion
Yes.
It looks like for PG 11 you can do 2.5, 3, or 3.1
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/
So try the below to get 3.0 for 11
yum install postgis30_11
To get 3.1 for 11
yum install postgis31_11
For 9.6 I've done:
install postgis24_96
for example -- so the version of PostgreSQL is always at the end and the number after PostGIS corresponds to the PostGIS minor version.
Only caution is I think each might have different dependencies and PostGIS 3.1 may overwrite PostGIS 3.0 since we stripped the minor version in lib by default.
Hope that helps,
Regina
> -----Original Message-----
> From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On
> Behalf Of pos...@khiplus.fr
> Sent: Tuesday, September 7, 2021 11:56 AM
> To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
> Subject: Re: [postgis-users] CentOS : postgis compatibility with postgresql.
>
> Thanks, it pass.
>
> An other question but it is possible to choose the postgresql version to install
> with postgis ?
>
> Regards
>
> Le 07.09.2021 16:01, Regina Obe a crit :
> >> ---> installed
It looks like for PG 11 you can do 2.5, 3, or 3.1
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/
So try the below to get 3.0 for 11
yum install postgis30_11
To get 3.1 for 11
yum install postgis31_11
For 9.6 I've done:
install postgis24_96
for example -- so the version of PostgreSQL is always at the end and the number after PostGIS corresponds to the PostGIS minor version.
Only caution is I think each might have different dependencies and PostGIS 3.1 may overwrite PostGIS 3.0 since we stripped the minor version in lib by default.
Hope that helps,
Regina
> -----Original Message-----
> From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On
> Behalf Of pos...@khiplus.fr
> Sent: Tuesday, September 7, 2021 11:56 AM
> To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
> Subject: Re: [postgis-users] CentOS : postgis compatibility with postgresql.
>
> Thanks, it pass.
>
> An other question but it is possible to choose the postgresql version to install
> with postgis ?
>
> Regards
>
> >> --> 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
> >> 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
pos...@khiplus.fr
Sep 8, 2021, 3:16:14 AM9/8/21
to PostGIS Users Discussion
Yes thx i can install all theses postgis versions.
Sorry my question was not clear.
But postgis dependencies install the postgresql 11.13 version by
default, my question is more to know if (and how) i can choose a
specific postgresql version : ex : postgresql11-11.2-1PGDG.rhel7.x86_64
?
I don't know how to do that in centos...
Sorry my question was not clear.
But postgis dependencies install the postgresql 11.13 version by
default, my question is more to know if (and how) i can choose a
specific postgresql version : ex : postgresql11-11.2-1PGDG.rhel7.x86_64
?
I don't know how to do that in centos...
Regards,
Regina Obe
Sep 11, 2021, 12:31:03 AM9/11/21
to PostGIS Users Discussion
Hmm if you install postgis with the version of PostgreSQL like below, it should install PG 12 since that one depends on PG 12 (it's all in the name)
# this is for pg12
yum install postgis31_12
#this is for pg11
yum install postgis31_11
That said, I usually install PostgreSQL first and make sure all looks good before I start installing non-contrib extensions.
Below are scribblings from my notes last time I did this. Things may have changed a bit since, but hopefully this helps.
To install a PostgreSQL version in Centos using yum.postgresql.org
#this will install 12 client and contrib extensions (those packaged with PostgreSQL)
# change the 12 with the version you want to install.
yum install postgresql12 postgresql12-server postgresql12-contrib
#this one if you need to compile custom extensions, this didn't work for me in older centos because of the clang compiler differences, I couldn't get a new enough clang
yum install postgresql12-devel
Then initialize the cluster
#initialize cluster by default cluster will be created in /var/lib/pgsql/12/data
/usr/pgsql-12/bin/postgresql-12-setup initdb
# start
systemctl start postgresql-12
#configure to start on reboot
systemctl enable postgresql-12
pre-10 is a bit different
yum install postgresql96 postgresql96-server postgresql96-libs postgresql96-contrib postgresql96-devel
#initialize cluster
/usr/pgsql-9.6/bin/postgresql96-setup initdb #creates here /var/lib/pgsql/9.6/data
> -----Original Message-----
> From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On
> Behalf Of pos...@khiplus.fr
> Sent: Wednesday, September 8, 2021 3:16 AM
> To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
> Subject: Re: [postgis-users] CentOS : postgis compatibility with postgresql.
>
> >> >> ---> Package
> >> >> ---> be
> >> >> ---> be
> >> >> --> libcryptsetup.so.12(CRYPTSETUP_2.0)(64bit)
> >> >> ---> installed
# this is for pg12
yum install postgis31_12
#this is for pg11
yum install postgis31_11
That said, I usually install PostgreSQL first and make sure all looks good before I start installing non-contrib extensions.
Below are scribblings from my notes last time I did this. Things may have changed a bit since, but hopefully this helps.
To install a PostgreSQL version in Centos using yum.postgresql.org
#this will install 12 client and contrib extensions (those packaged with PostgreSQL)
# change the 12 with the version you want to install.
yum install postgresql12 postgresql12-server postgresql12-contrib
#this one if you need to compile custom extensions, this didn't work for me in older centos because of the clang compiler differences, I couldn't get a new enough clang
yum install postgresql12-devel
Then initialize the cluster
#initialize cluster by default cluster will be created in /var/lib/pgsql/12/data
/usr/pgsql-12/bin/postgresql-12-setup initdb
# start
systemctl start postgresql-12
#configure to start on reboot
systemctl enable postgresql-12
pre-10 is a bit different
yum install postgresql96 postgresql96-server postgresql96-libs postgresql96-contrib postgresql96-devel
#initialize cluster
/usr/pgsql-9.6/bin/postgresql96-setup initdb #creates here /var/lib/pgsql/9.6/data
> -----Original Message-----
> From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On
> Behalf Of pos...@khiplus.fr
> Sent: Wednesday, September 8, 2021 3:16 AM
> To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
> Subject: Re: [postgis-users] CentOS : postgis compatibility with postgresql.
>
> Yes thx i can install all theses postgis versions.
> Sorry my question was not clear.
> But postgis dependencies install the postgresql 11.13 version by default, my
> question is more to know if (and how) i can choose a specific postgresql
> version : ex : postgresql11-11.2-1PGDG.rhel7.x86_64
> ?
> I don't know how to do that in centos...
>
> Regards,
>
> Le 07.09.2021 18:49, Regina Obe a crit :
> Sorry my question was not clear.
> But postgis dependencies install the postgresql 11.13 version by default, my
> question is more to know if (and how) i can choose a specific postgresql
> version : ex : postgresql11-11.2-1PGDG.rhel7.x86_64
> ?
> I don't know how to do that in centos...
>
> Regards,
>
> >> >> installed
> >> >> ---> Package systemd-sysv.x86_64 0:219-78.el7_9.3 will be
> >> >> ---> installed
> >> >> ---> Package systemd-sysv.x86_64 0:219-78.el7_9.3 will be
> >> >> 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
> >> >> --> 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
> >> >> ---> 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
> >> >> 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
Reply all
Reply to author
Forward
0 new messages