BUG #15574: Upgrading postgis broke pg_dump

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

BUG #15574: Upgrading postgis broke pg_dump

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15574
Logged by:          Karl Pinc
Email address:      [hidden email]
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".