[postgis-users] 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"

[Matthew Baker]

For what it's worth, the Ubuntu/Debian install was causing this same 
problem from the PostgreSQL APT repository

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.

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

By forcing the version of postgresql-contrib to 9.4, it illeviated the 
problem:

sudo apt-get install postgresql-9.4-postgis-2.1 pgadmin3*postgresql-contrib-9.4*

Not sure if there is an equivalent problem going on...

(I've updated the Ubuntu/Debian instructions here:)

https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

-m



On 1/15/2016 7:35 AM, Paul Ramsey wrote:
> Thanks for confirming, I've notified the pgdg packager.
> P
>
> On Fri, Jan 15, 2016 at 6:25 AM, Paul Edwards <pjfingers at gmail.com> wrote:
>> 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:
>>> 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:
>>>> 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 <Moti.U... at ness.com> wrote:
>>>>> 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: 'postgi... at lists.osgeo.org'
>>>>> 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
>>>>>
>>>>> https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)
>>>>>
>>>>>
>>>>>
>>>>> 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
>>>>>
>>>>> https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.
>>>>>
>>>>>
>>>>>
>>>>> 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 Mail... at ness.com 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
>>>>> postgi... at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/postgis-users
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgi... at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160120/e2e91873/attachment.html>