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:[email protected]] On > Behalf Of [email protected] > Sent: Wednesday, September 8, 2021 3:16 AM > To: PostGIS Users Discussion <[email protected]> > 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 : > > 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 > _______________________________________________ > 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
