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

Поиск
Список
Период
Сортировка
От John Harvey
Тема 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
Дата
Msg-id CABcP5fgK_-OpJOT5xbQYsCjCMYVqx-TEaB4hbN=o=S0ugmGSbw@mail.gmail.com
обсуждение исходный текст
Ответ на 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>)
Список pgsql-pkg-yum
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Christoph Berg
Дата:
Сообщение: 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
Следующее
От: Martín Marqués
Дата:
Сообщение: Broken PG10 packages for F28