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:[email protected]] On > Behalf Of [email protected] > Sent: Tuesday, September 7, 2021 11:56 AM > To: PostGIS Users Discussion <[email protected]> > 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 : > > 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.htm > > l > > > > So you need to add that as well. > > > > > >> -----Original Message----- > >> From: postgis-users [mailto:[email protected]] On > >> Behalf Of [email protected] > >> Sent: Tuesday, September 7, 2021 9:30 AM > >> To: [email protected] > >> Subject: [postgis-users] CentOS : postgis compatibility with > >> postgresql. > >> > >> 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 > >> [email protected] > >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > https://lists.osgeo.org/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
