[postgis-users] PostGIS on Centos 7
Mark Jackson
We have a managed server with PostGreSQL / PostGIS and Centos. We
asked our ISP about moving to a new server and they said
PostGIS "would not work well with CentOS7, certainly not without a
great deal of customisation and it's something we would not
recommend. " (I am not convinced they know much about PostGIS though...)
Does PostGIS work well on Centos 7?
Is there a web page that says PostGIS works well on Centos 7 - so I
can send it to the ISP ?
Back in 2011 the same ISP installed PostgreSQL 9.0.2 with
PostGIS onto Centos 5 fairly easily. I don't know exactly why they
are reluctant to install PostGIS on Centos 7 - they have not given
details. We would be happy to use the most up-to-date Postgresql and PostGIS.
(I'm reluctant to shift to another ISP because up to now, these guys
have been excellent. I'd like to convince them that PostGIS is fine
on Centos 7.)
Thanks
Mark
*******************************************************************************************
Cambridge Environmental Research Consultants Ltd. cannot accept any
responsibility for the accuracy or completeness of this message as
it has been transmitted over a public network.
This e-mail and any files transmitted with it are private and intended
solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient, this e-mail and any
accompanying files have been transmitted to you in error. You may not
copy, distribute or make any other use of the information contained in
them.
CERC is a trading name of Cambridge Environmental Research Consultants Ltd,
registered at Cardiff with number 1926883. Registered Office address:
3 Kings Parade, Cambridge, CB2 1SJ.
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
Christophe Pettus
> On Apr 25, 2018, at 08:09, Mark Jackson <mark.j...@cerc.co.uk> wrote:
>
> Hi there
>
> We have a managed server with PostGreSQL / PostGIS and Centos. We asked our ISP about moving to a new server and they said PostGIS "would not work well with CentOS7, certainly not without a great deal of customisation and it's something we would not recommend. " (I am not convinced they know much about PostGIS though...)
I... I have no idea what they mean. You can install it directly from the Centos 7 community packages, AFAIK:
Regina Obe
Then again I have always used the community packages yum.postgresql.org since the ones that come packaged with distros are generally too old and lacking in other ways.
From issues of past, you are almost always better off going with newer CentOS. The reason being is that even using the community packages, some packages are picked up from EPEL stable of your repo. So that means a newer CentOS would probably get you a newer GEOS / GDAL. Eventually we won't be supporting GEOS 3.5 which is the latest on older CentOS distros carry as I recall.
That said, I would push them to ask them where they get their information. Perhaps they have some knowledge about some issue that they haven't raised with packagers or PostGIS development that can easily be resolved if we knew about it.
Thanks,
Regina
Phil Hurvitz
Centos 7 using the community packages.
-P.
**************************************************************
Philip M. Hurvitz, PhD | Research Assistant Professor | UW-CBE
Urban Form Lab | 1107 NE 45th Street, Suite 535 | Box 354802
University of Washington, Seattle, Washington 98195-4802, USA
phur...@u.washington.edu | http://gis.washington.edu/phurvitz
"What is essential is invisible to the eye." -de Saint-Exupéry
**************************************************************
On 2018-04-25 12:00, postgis-us...@lists.osgeo.org wrote:
> Message: 1
> Date: Wed, 25 Apr 2018 16:09:31 +0100
> From: Mark Jackson <mark.j...@cerc.co.uk>
> To: postgi...@lists.osgeo.org
> Subject: [postgis-users] PostGIS on Centos 7
> Message-ID: <7.0.1.0.0.201804...@cerc.co.uk>
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
> Hi there
>
> We have a managed server with PostGreSQL / PostGIS and Centos. We
> asked our ISP about moving to a new server and they said
> PostGIS "would not work well with CentOS7, certainly not without a
> great deal of customisation and it's something we would not
> recommend. " (I am not convinced they know much about PostGIS though...)
>
Bryan Hall
Do you have a cheat-sheet for installation of both PostgreSQL and PostGIS with all the required extensions?
I'm actually installing it onto OEL 7 AKA "Red Hat Enterprise Linux Server release 7.4 (Maipo)", and have tried to follow the following guide to getting this all working. As they say, close but no cigar. Possibly because of version differences, but I'm not sure as this is the first time I've tried to do it from scratch.
http://www.postgresonline.com/article_pfriendly/362.html
After downloading and making, installing all the dependencies (including GDAL), when trying to add postgis:
sudo yum install postgis2_10 postgis2_10-client
I get:
--> Finished Dependency Resolution
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libarmadillo.so.8()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libfreexl.so.1()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libCharLS.so.1()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libopenjp2.so.7()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libnetcdf.so.7()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libcfitsio.so.2()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libdap.so.17()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libhdf5.so.8()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libdapserver.so.7()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libgta.so.0()(64bit)
Error: Package: gdal-libs-1.11.4-12.rhel7.x86_64 (pgdg10)
Requires: libdapclient.so.6()(64bit)
Error: Package: postgis24_10-2.4.4-1.rhel7.x86_64 (pgdg10)
Requires: hdf5
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
I don't understand why that is. Can postGIS not use GDAL 2.2.4 libs?
Regards,
Bryan
-----Original Message-----
From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On Behalf Of Phil Hurvitz
Sent: Wednesday, April 25, 2018 14:07
To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
I have been using PostGIS without complaint for quite some time on Centos 7 using the community packages.
-P.
**************************************************************
> of this message as it has been transmitted over a public network.
>
> This e-mail and any files transmitted with it are private and intended
> solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient, this e-mail and any
> accompanying files have been transmitted to you in error. You may not
> copy, distribute or make any other use of the information contained in
> them.
>
> CERC is a trading name of Cambridge Environmental Research Consultants
> Ltd, registered at Cardiff with number 1926883. Registered Office address:
> 3 Kings Parade, Cambridge, CB2 1SJ.
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
________________________________
This email (and attachments if any) is intended only for the use of the individual or entity to which it is addressed, and may contain information that is confidential or privileged and exempt from disclosure under applicable law. If the reader of this email is not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and destroy all copies of the email (and attachments if any).
Lars Aksel Opsahl
On CentOS Linux release 7.4.1708 (Core) this worked without any problems a couple of weeks ago.
yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
yum install postgresql10 postgresql10-server postgis24_10 postgis24_10-utils.x86_64 postgis24_10-client.x86_64
The gdal packages was installed by default by the commands above
gdal-doc-1.11.4-12.rhel7.noarch Tue 03 Apr 2018 07:40:49 AM CEST
gdal-python-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:40 AM CEST
gdal-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:40 AM CEST
gdal-perl-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:39 AM CEST
gdal-devel-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:39 AM CEST
gdal-libs-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:38:49 AM CEST
Installed on kernel 3.19 changed to kernel 4.16 last week.
Lars
________________________________________
Fra: postgis-users <postgis-us...@lists.osgeo.org> på vegne av Bryan Hall <bryan...@chk.com>
Sendt: 25. april 2018 23:17
Til: PostGIS Users Discussion
Emne: Re: [postgis-users] [EXTERNAL] Re: PostGIS on Centos 7
Bryan Hall
Thanks for the reply. Unfortunately that had no change on this OS build. It seems I'm missing the armadillo, etc libraries, So I tried grabbing that one to start with from here and adding it:
https://centos.pkgs.org/7/epel-x86_64/armadillo-8.300.0-1.el7.x86_64.rpm.html
Of course that led to more dependencies to get that isntalled (yeah):
$ sudo rpm -Uvh armadillo-8.300.0-1.el7.x86_64.rpm
warning: armadillo-8.300.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 352c64e5: NOKEY
error: Failed dependencies:
libarpack.so.2()(64bit) is needed by armadillo-8.300.0-1.el7.x86_64
libhdf5.so.8()(64bit) is needed by armadillo-8.300.0-1.el7.x86_64
liblapack.so.3()(64bit) is needed by armadillo-8.300.0-1.el7.x86_64
libopenblaso.so.0()(64bit) is needed by armadillo-8.300.0-1.el7.x86_64
libsuperlu.so.5.1()(64bit) is needed by armadillo-8.300.0-1.el7.x86_64
I'll probably eventually blunder my way into a working set, but any suggestions are appreciated. Our OS admins prefer RH, but we switched that all out a year ago to OEL to save money on maintenance costs. We have other PostgreSQL databases running on it, but this is the first PostGIS enabled db. I plan to publish a step-by-step list when it finally all works.
The overall goal is to replace our longtime Oracle Spatial databases with PostGIS. Of course easier said than done since that also includes the rewrite all the stored procedures, modification of any spotfire reports, repointing FME and UC4 jobs, and having it all working in production with the corporate ESRI software by this time next year. Should be an adventure...
Bryan
-----Original Message-----
From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On Behalf Of Lars Aksel Opsahl
Sent: Wednesday, April 25, 2018 22:52
To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
Subject: Re: [postgis-users] [EXTERNAL] Re: PostGIS on Centos 7
Hi
On CentOS Linux release 7.4.1708 (Core) this worked without any problems a couple of weeks ago.
The gdal packages was installed by default by the commands above
gdal-doc-1.11.4-12.rhel7.noarch Tue 03 Apr 2018 07:40:49 AM CEST
gdal-python-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:40 AM CEST
gdal-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:40 AM CEST
gdal-perl-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:39 AM CEST
gdal-devel-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:39:39 AM CEST
gdal-libs-1.11.4-12.rhel7.x86_64 Tue 03 Apr 2018 07:38:49 AM CEST
Installed on kernel 3.19 changed to kernel 4.16 last week.
Lars
________________________________________
Fra: postgis-users <postgis-us...@lists.osgeo.org> på vegne av Bryan Hall <bryan...@chk.com>
Sendt: 25. april 2018 23:17
Til: PostGIS Users Discussion
Emne: Re: [postgis-users] [EXTERNAL] Re: PostGIS on Centos 7
Phil,
Do you have a cheat-sheet for installation of both PostgreSQL and PostGIS with all the required extensions?
I'm actually installing it onto OEL 7 AKA "Red Hat Enterprise Linux Server release 7.4 (Maipo)", and have tried to follow the following guide to getting this all working. As they say, close but no cigar. Possibly because of version differences, but I'm not sure as this is the first time I've tried to do it from scratch.
postgis-users mailing list
postgi...@lists.osgeo.org
Regina Obe
You should just add the epel repo to your list of repos from what you are experiencing, sounds like you don't have it.
GDAL has a mess of dependencies so if you do it one by one you'll be sitting there for a whiel.
To add an epel repo you should be able to do:
sudo yum install epel-release
Lars,
https://centos.pkgs.org/7/epel-x86_64/armadillo-8.300.0-1.el7.x86_64.rpm.html
Bryan
Hi
Lars
________________________________________
Fra: postgis-users <postgis-us...@lists.osgeo.org> p vegne av Bryan Hall <bryan...@chk.com>
Phil,
I get:
Regards,
Bryan
-P.
"What is essential is invisible to the eye." -de Saint-Exup ry
Phil Hurvitz
Hi Bryan,
I didn't have any notes, but as I recall I followed the tips from Regina and Lars. The yum commands installed all dependencies.
In the past I've installed from source, which required
installing a bunch of dependencies first. The community packages
took all the headache out of this.
-P. ************************************************************** Philip M. Hurvitz, PhD | Research Assistant Professor | UW-CBE Urban Form Lab | 1107 NE 45th Street, Suite 535 | Box 354802 University of Washington, Seattle, Washington 98195-4802, USA
phur...@u.washington.edu | http://gis.washington.edu/phurvitz "What is essential is invisible to the eye." -de Saint-Exupéry **************************************************************
Date: Thu, 26 Apr 2018 12:45:01 -0400 From: "Regina Obe" <l...@pcorp.us>
To: "'PostGIS Users Discussion'" <postgi...@lists.osgeo.org>
Subject: Re: [postgis-users] [EXTERNAL] Re: PostGIS on Centos 7 Message-ID: <000001d3dd7d$ec0cd1f0$c42675d0$@pcorp.us> Content-Type: text/plain; charset="utf-8" Bryan, You should just add the epel repo to your list of repos from what you are experiencing, sounds like you don't have it. GDAL has a mess of dependencies so if you do it one by one you'll be sitting there for a whiel. To add an epel repo you should be able to do: sudo yum install epel-release -----Original Message----- From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On Behalf Of Bryan Hall Sent: Thursday, April 26, 2018 8:12 AM To: PostGIS Users Discussion <postgi...@lists.osgeo.org>
Devrim Gündüz
Hi,
On Thu, 2018-04-26 at 12:45 -0400, Regina Obe wrote:
> To add an epel repo you should be able to do:
>
> sudo yum install epel-release
repo package...
Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR