<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><tt>Hi Bryan,<br>
</tt></p>
<p><tt>I didn't have any notes, but as I recall I followed the tips
from Regina and Lars. The yum commands installed all
dependencies.</tt></p>
<p><tt>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.</tt><br>
</p>
<pre class="moz-signature" cols="72">-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
<a class="moz-txt-link-abbreviated" href="mailto:phurvitz@u.washington.edu">phurvitz@u.washington.edu</a> | <a class="moz-txt-link-freetext" href="http://gis.washington.edu/phurvitz">http://gis.washington.edu/phurvitz</a>
"What is essential is invisible to the eye." -de Saint-Exupéry
************************************************************** </pre>
<div class="moz-cite-prefix">On 04/26/2018 12:00 PM,
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:mailman.43.1524769202.22376.postgis-users@lists.osgeo.org">
<pre wrap="">Date: Thu, 26 Apr 2018 12:45:01 -0400
From: "Regina Obe" <a class="moz-txt-link-rfc2396E" href="mailto:lr@pcorp.us" moz-do-not-send="true"><lr@pcorp.us></a>
To: "'PostGIS Users Discussion'" <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true"><postgis-users@lists.osgeo.org></a>
Subject: Re: [postgis-users] [EXTERNAL] Re: PostGIS on Centos 7
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:000001d3dd7d$ec0cd1f0$c42675d0$@pcorp.us" moz-do-not-send="true"><000001d3dd7d$ec0cd1f0$c42675d0$@pcorp.us></a>
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 [<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org" moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of Bryan Hall
Sent: Thursday, April 26, 2018 8:12 AM
To: PostGIS Users Discussion <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true"><postgis-users@lists.osgeo.org></a>
Subject: Re: [postgis-users] [EXTERNAL] Re: PostGIS on Centos 7
Lars,
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:
<a class="moz-txt-link-freetext" href="https://centos.pkgs.org/7/epel-x86_64/armadillo-8.300.0-1.el7.x86_64.rpm.html" moz-do-not-send="true">https://centos.pkgs.org/7/epel-x86_64/armadillo-8.300.0-1.el7.x86_64.rpm.html</a>
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 [<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org" moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of Lars Aksel Opsahl
Sent: Wednesday, April 25, 2018 22:52
To: PostGIS Users Discussion <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true"><postgis-users@lists.osgeo.org></a>
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.
yum install <a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=https-3A__download.postgresql.org_pub_repos_yum_10_redhat_rhel-2D7-2Dx86-5F64_pgdg-2Dcentos10-2D10-2D2.noarch.rpm&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=rZQr345eIWScM32VqEtYyu8vL1Dk_mGuqY_IbYsjnlY&e=" moz-do-not-send="true">https://urldefense.proofpoint.com/v2/url?u=https-3A__download.postgresql.org_pub_repos_yum_10_redhat_rhel-2D7-2Dx86-5F64_pgdg-2Dcentos10-2D10-2D2.noarch.rpm&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=rZQr345eIWScM32VqEtYyu8vL1Dk_mGuqY_IbYsjnlY&e=</a>
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 <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users-bounces@lists.osgeo.org" moz-do-not-send="true"><postgis-users-bounces@lists.osgeo.org></a> p vegne av Bryan Hall <a class="moz-txt-link-rfc2396E" href="mailto:bryan.hall@chk.com" moz-do-not-send="true"><bryan.hall@chk.com></a>
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.
<a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.postgresonline.com_article-5Fpfriendly_362.html&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=h-R-2NdxHVhN1QirYoAzBXEd457MNTeSkzN4Rccn2F8&e=" moz-do-not-send="true">https://urldefense.proofpoint.com/v2/url?u=http-3A__www.postgresonline.com_article-5Fpfriendly_362.html&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=h-R-2NdxHVhN1QirYoAzBXEd457MNTeSkzN4Rccn2F8&e=</a>
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 [<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org" moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of Phil Hurvitz
Sent: Wednesday, April 25, 2018 14:07
To: PostGIS Users Discussion <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true"><postgis-users@lists.osgeo.org></a>
Subject: [EXTERNAL] Re: [postgis-users] PostGIS on Centos 7
I have been using PostGIS without complaint for quite some time on 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 <a class="moz-txt-link-abbreviated" href="mailto:phurvitz@u.washington.edu" moz-do-not-send="true">phurvitz@u.washington.edu</a> | <a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__gis.washington.edu_phurvitz&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=cjKf86G4uPnnLqLkgUEz_WM5sLnNhPYUt_f-tlA6TBc&s=wzInbtqEu5E28kzPyg0LTPBsH25ihh2uIMoXMZ40ZDo&e=" moz-do-not-send="true">https://urldefense.proofpoint.com/v2/url?u=http-3A__gis.washington.edu_phurvitz&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=cjKf86G4uPnnLqLkgUEz_WM5sLnNhPYUt_f-tlA6TBc&s=wzInbtqEu5E28kzPyg0LTPBsH25ihh2uIMoXMZ40ZDo&e=</a>
"What is essential is invisible to the eye." -de Saint-Exup ry
**************************************************************
On 2018-04-25 12:00, <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-request@lists.osgeo.org" moz-do-not-send="true">postgis-users-request@lists.osgeo.org</a> wrote:
</pre>
<blockquote type="cite" style="color: #000000;">
<pre wrap="">Message: 1
Date: Wed, 25 Apr 2018 16:09:31 +0100
From: Mark Jackson <a class="moz-txt-link-rfc2396E" href="mailto:mark.jackson@cerc.co.uk" moz-do-not-send="true"><mark.jackson@cerc.co.uk></a>
To: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
Subject: [postgis-users] PostGIS on Centos 7
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:7.0.1.0.0.20180425160055.04b27ad0@cerc.co.uk" moz-do-not-send="true"><7.0.1.0.0.20180425160055.04b27ad0@cerc.co.uk></a>
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...)
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.
</pre>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=cjKf86G4uPnnLqLkgUEz_WM5sLnNhPYUt_f-tlA6TBc&s=gig9ye9iFB8sZapAjrIXrChFWZVXsW4c2cJvW3yvd8k&e=" moz-do-not-send="true">https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=cjKf86G4uPnnLqLkgUEz_WM5sLnNhPYUt_f-tlA6TBc&s=gig9ye9iFB8sZapAjrIXrChFWZVXsW4c2cJvW3yvd8k&e=</a>
________________________________
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).
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=XDQroNC4WL6iemmAJTP5jAO7ku3i3t9QqhIdcsuAhwg&e=" moz-do-not-send="true">https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=XDQroNC4WL6iemmAJTP5jAO7ku3i3t9QqhIdcsuAhwg&e=</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=XDQroNC4WL6iemmAJTP5jAO7ku3i3t9QqhIdcsuAhwg&e=" moz-do-not-send="true">https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.osgeo.org_mailman_listinfo_postgis-2Dusers&d=DwIGaQ&c=M7nMI6M-Uv3ihEfN-QJ3_sQdVexoO64eU4Ftr4lnVk0&r=-89XSUoV_kZKlHf89FQGuyqPyUjA53juyA-7r7GoZVA&m=e5on-jnOzkmmjhumlEu8KFMChf3l1Lt5UZ1GtCKCfro&s=XDQroNC4WL6iemmAJTP5jAO7ku3i3t9QqhIdcsuAhwg&e=</a>
________________________________
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).
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>