BUG #15574: Upgrading postgis broke pg_dump

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15574: Upgrading postgis broke pg_dump
Дата
Msg-id 15574-cec279413ee434af@postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15574
Logged by:          Karl Pinc
Email address:      kop@meme.com
PostgreSQL version: 10.6
Operating system:   RHEL 7.6
Description:

On Jan 2 2019 upgraded to postgis24_10.x86_64 version 2.4.6-2.rhel7
from the pgdg10 repo.

Now, pg_dump gives me the following failure message:
pg_dump: [archiver (db)] query failed: ERROR:  could not load library
"/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so:
undefined symbol: GEOSFrechetDistanceDensify

The following geos pacakges from pgdg10 repo were installed:
geos
geos36
geos37

Removing the geos36 package from the system resolved the problem.

I don't believe that we've ever manually installed geos packages,
although I could be wrong.  I this this situation arose in the normal
course of doing "yum upgrade".


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SELECT do not return all rows depending on selected columns
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15575: Using RDS upgrade option from 9.6 to 10.4 Upsert will notinsert records but complete successfully