<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
For what it's worth, the Ubuntu/Debian install was causing this same
problem from the PostgreSQL APT repository<br>
<br>
What was happening was when installing the postgresql-contrib
package, it was defaulting to the 9.5 version of the package, and so
was installing another instance of PostgreSQL - so versions 9.4 and
9.5 were starting up.<br>
<br>
So when I tried to install the postgis extension, it was giving a
similar error - I believe because it was trying to create the
extension in the 9.5 version of PG, while PGIS was installed in the
9.4 version<br>
<br>
By forcing the version of postgresql-contrib to 9.4, it illeviated
the problem:<br>
<pre class="wiki">sudo apt-get install postgresql-9.4-postgis-2.1 pgadmin3 <b>postgresql-contrib-9.4</b></pre>
Not sure if there is an equivalent problem going on...<br>
<br>
(I've updated the Ubuntu/Debian instructions here:)<br>
<br>
<a class="moz-txt-link-freetext" href="https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt">https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt</a><br>
<br>
-m<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 1/15/2016 7:35 AM, Paul Ramsey
wrote:<br>
</div>
<blockquote
cite="mid:CACowWR3+NMiS1h167YrNu=1srt-OS7ja-YKkyoO=JCVOaOLd=g@mail.gmail.com"
type="cite">
<pre wrap="">Thanks for confirming, I've notified the pgdg packager.
P
On Fri, Jan 15, 2016 at 6:25 AM, Paul Edwards <a class="moz-txt-link-rfc2396E" href="mailto:pjfingers@gmail.com"><pjfingers@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry for the spam, but as you suspected:
yum deplist postgis2_95
****bunch of dependencies****
dependency: geos >= 3.4.2
On Friday, January 15, 2016 at 9:20:33 AM UTC-5, Paul Edwards wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Was debugging the exact issue yesterday. Updating GEOS to 3.5 did the
trick for me. This is the version of geos provided for in the pgdg95 repo.
On Thursday, January 14, 2016 at 9:13:13 AM UTC-5, Paul Ramsey wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Check the versions of the GEOS rpm you have installed, and also check
the "requires" declarations for the postgis rpm. Probably you'll find
the GEOS rpm is version 3.4 and that the postgis rpm doesn't declare a
dependency for geos 3.5. See if you can track down a GEOS 3.5 rpm.
P
On Thu, Jan 14, 2016 at 2:04 AM, Moti Umansky <a class="moz-txt-link-rfc2396E" href="mailto:Moti.U...@ness.com"><Moti.U...@ness.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I have reproduced the issue when installing with yum install from the
internet.
I think there is something wrong with the last version installation on
Oracle Linux (or Red Hat).
Has anyone succeeded to install the last version on Oracle Linux or Red
Hat?
Thanks,
Moti
From: Moti Umansky
Sent: יום א 10 ינואר 2016 18:08
To: '<a class="moz-txt-link-abbreviated" href="mailto:postgi...@lists.osgeo.org">postgi...@lists.osgeo.org</a>'
Subject: CREATE EXTENSION postgis fails with "ERROR: could not load
library
"/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so:
undefined symbol: GEOSClipByRect"
Hi
I'm trying to install the new 9.5 Postgres version with Postgis 2.2
(downloaded from
<a class="moz-txt-link-freetext" href="https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/">https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/</a>)
When I issue "CREATE EXTENSION postgis", I'm getting :
ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so":
/usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect
OS : Oracle Linux 6U7
Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled
by gcc
(GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"
I have tried to reproduce the issue on Postgres 9.4.5 downloaded from
<a class="moz-txt-link-freetext" href="https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64">https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64</a>.
The issue was not reproduced.
Thanks,
Moti
____________________________
Powered By Office365
The information contained in this communication is intended solely for
the
use of the individual or entity to whom it is addressed and others
authorized to receive it.
It may contain confidential or legally privileged information.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance on
the
contents of this information is strictly prohibited and may be
unlawful.
If you have received this communication in error, please notify us
immediately by forwarding this email to <a class="moz-txt-link-abbreviated" href="mailto:Mail...@ness.com">Mail...@ness.com</a> and then
delete
it from your system.
Ness technologies is neither liable for the proper and complete
transmission
of the information contained in this communication nor for any delay in
its
receipt.
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgi...@lists.osgeo.org">postgi...@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/postgis-users">http://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgi...@lists.osgeo.org">postgi...@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/postgis-users">http://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/postgis-users">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>