[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] CentOS : postgis compatibility with postgresql.
From: "Regina Obe" <lr () pcorp ! us>
Date: 2021-09-11 4:30:54
Message-ID: 000001d7a6c5$cffcfa70$6ff6ef50$ () pcorp ! us
[Download RAW message or body]
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-users-bounces@lists.osgeo.org] On
> Behalf Of postgo@khiplus.fr
> Sent: Wednesday, September 8, 2021 3:16 AM
> To: PostGIS Users Discussion <postgis-users@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 :
> > 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-users-bounces@lists.osgeo.org] On
> > > Behalf Of postgo@khiplus.fr
> > > Sent: Tuesday, September 7, 2021 11:56 AM
> > > To: PostGIS Users Discussion <postgis-users@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 :
> > > > 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:postgis-users-bounces@lists.osgeo.org]
> > > > > On Behalf Of postgo@khiplus.fr
> > > > > Sent: Tuesday, September 7, 2021 9:30 AM
> > > > > To: postgis-users@lists.osgeo.org
> > > > > 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
> > > > > postgis-users@lists.osgeo.org
> > > > > https://lists.osgeo.org/mailman/listinfo/postgis-users
> > > >
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > postgis-users@lists.osgeo.org
> > > > https://lists.osgeo.org/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users@lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic