Postgres Pro
Downloads
Home   >   mailing lists

Re: [PostgreSQL YUM Repository - Bug #3710] (Resolved) RHEL7postgresql11 postgis2.5 fails with /usr/pgsql-11/lib/postgis-2.5.so:undefined symbol: geod_polygon_init - Mailing list pgsql-pkg-yum

From John Harvey
Subject Re: [PostgreSQL YUM Repository - Bug #3710] (Resolved) RHEL7postgresql11 postgis2.5 fails with /usr/pgsql-11/lib/postgis-2.5.so:undefined symbol: geod_polygon_init
Date
Msg-id CABcP5fgK_-OpJOT5xbQYsCjCMYVqx-TEaB4hbN=o=S0ugmGSbw@mail.gmail.com
Whole thread Raw
In response to Re: [PostgreSQL YUM Repository - Bug #3710] (Resolved) RHEL7postgresql11 postgis2.5 fails with /usr/pgsql-11/lib/postgis-2.5.so:undefined symbol: geod_polygon_init  (Christoph Berg <myon@debian.org>)
List pgsql-pkg-yum
Tree view
Hi Christoph (and others),

I believe the issue that remains could be pretty easily fixed when Devrim releases geos 3.7.0-2.  That patch version contains an Obsoletes so that geos37 will obsolete geos36, which I think would solve the functionality problem.  I did some testing locally with that change, and it seemed to work.  Since geos37 only adds functionality on top of geos36 and has no breaking changes, it should be an okay solution to solve the "having 2 geos's on at the same time is a problem" issue.

Regards,
  -John


-----------------------
John Harvey
(843) 628-5421
Crunchy Data
Enterprise PostgreSQL 


On Thu, Feb 21, 2019 at 8:26 AM Christoph Berg <myon@debian.org> wrote:
Re: Justin Pryzby 2019-01-07 <20190107215410.GA22493@telsasoft.com>
> This appears to be more or less same as issue #3710.  See earlier communiction,
> copied below.
>
> Just reinstalling postgis on a centos7 test server which previously ran
> postgres 11 beta.
>
> Installing : geos37-3.7.0-1.rhel7.1.x86_64
> Installing : postgis24_11-2.4.6-3.rhel7.x86_64
> Installing : postgis24_11-client-2.4.6-3.rhel7.x86_64
>
> sentinel=# \i /usr/pgsql-11/share/contrib/postgis-2.4/postgis.sql
> BEGIN
> SET
> DO
> CREATE FUNCTION
> psql:/usr/pgsql-11/share/contrib/postgis-2.4/postgis.sql:95: ERROR:  could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so: undefined symbol: GEOSFrechetDistanceDensify

This has just popped up again on IRC, with postgis24_96-2.4.6-3.rhel7.x86_64

Why does postgis-2.4.so even "see" the geos37 package?

> [pryzbyj@template0 ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so
>         libgeos_c.so.1 => /usr/geos36/lib64/libgeos_c.so.1 (0x00007f3e50e6e000)
>         libgeos-3.6.2.so => /usr/geos36/lib64/libgeos-3.6.2.so (0x00007f3e4f12e000)
>
> Fixed with: rpm -e geos36-3.6.2-3.1.rhel7.x86_64
> Should declare the RPM equivalent of debian's "Breaks" ??

Christoph

pgsql-pkg-yum by date:

Previous
From: Christoph Berg
Date:
Subject: Re: [PostgreSQL YUM Repository - Bug #3710] (Resolved) RHEL7postgresql11 postgis2.5 fails with /usr/pgsql-11/lib/postgis-2.5.so:undefined symbol: geod_polygon_init
Next
From: Martín Marqués
Date:
Subject: Broken PG10 packages for F28