[postgis-users] PostGIS raster library problem

[Philip M. Hurvitz]

Hi all, and happy new year!

I'm having problems with pg_dump, and "yum update".

My dump is failing at the point where a raster is being dumped:

...
pg_dump: error: Dumping the contents of table "os_be_slope_2009" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR:  could not load library "/usr/pgsql-9.6/lib/rtpostgis-2.4.so": /usr/gdal30/lib/libgdal.so.26: undefined symbol: GEOSMakeValid_r


If I try to select a value from that raster I get the same error:

5432 assessor=# select * from gis.os_be_slope_2009 limit 1;
ERROR:  could not load library "/usr/pgsql-9.6/lib/rtpostgis-2.4.so": /usr/gdal30/lib/libgdal.so.26: undefined symbol: GEOSMakeValid_r



And when attempting an update:

# yum update
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: centos.s.uw.edu
 * centos-sclo-rh: centos.s.uw.edu
 * centos-sclo-sclo: centos.s.uw.edu
 * epel: d2lzkl7pfhq30w.cloudfront.net
 * extras: centos.s.uw.edu
 * updates: centos.s.uw.edu
Resolving Dependencies
--> Running transaction check
---> Package fribidi.x86_64 0:1.0.2-1.el7 will be updated
---> Package fribidi.x86_64 0:1.0.2-1.el7_7.1 will be an update
---> Package fribidi-devel.x86_64 0:1.0.2-1.el7 will be updated
---> Package fribidi-devel.x86_64 0:1.0.2-1.el7_7.1 will be an update
---> Package geos37.x86_64 0:3.7.1-1.rhel7 will be updated
--> Processing Dependency: geos37 = 3.7.1-1.rhel7 for package: geos37-python-3.7.1-1.rhel7.x86_64
--> Processing Dependency: libgeos-3.7.1.so()(64bit) for package: geos37-python-3.7.1-1.rhel7.x86_64
---> Package geos37.x86_64 0:3.7.2-2.rhel7 will be an update
---> Package geos37-devel.x86_64 0:3.7.1-1.rhel7 will be updated
---> Package geos37-devel.x86_64 0:3.7.2-2.rhel7 will be an update
---> Package open-vm-tools.x86_64 0:10.3.0-2.el7 will be updated
---> Package open-vm-tools.x86_64 0:10.3.0-2.el7_7.1 will be an update
---> Package open-vm-tools-desktop.x86_64 0:10.3.0-2.el7 will be updated
---> Package open-vm-tools-desktop.x86_64 0:10.3.0-2.el7_7.1 will be an update
---> Package pgdg-redhat-repo.noarch 0:42.0-5 will be updated
---> Package pgdg-redhat-repo.noarch 0:42.0-6 will be an update
--> Finished Dependency Resolution
Error: Package: geos37-python-3.7.1-1.rhel7.x86_64 (@pgdg11)
           Requires: libgeos-3.7.1.so()(64bit)
           Removing: geos37-3.7.1-1.rhel7.x86_64 (@pgdg11)
               libgeos-3.7.1.so()(64bit)
           Updated By: geos37-3.7.2-2.rhel7.x86_64 (pgdg10)
              ~libgeos-3.7.2.so()(64bit)
Error: Package: geos37-python-3.7.1-1.rhel7.x86_64 (@pgdg11)
           Requires: geos37 = 3.7.1-1.rhel7
           Removing: geos37-3.7.1-1.rhel7.x86_64 (@pgdg11)
               geos37 = 3.7.1-1.rhel7
           Updated By: geos37-3.7.2-2.rhel7.x86_64 (pgdg10)
               geos37 = 3.7.2-2.rhel7
           Available: geos37-3.7.0-1.rhel7.x86_64 (pgdg94)
               geos37 = 3.7.0-1.rhel7
           Available: geos37-3.7.0-2.rhel7.x86_64 (pgdg10)
               geos37 = 3.7.0-2.rhel7
           Available: geos37-3.7.2-1.rhel7.x86_64 (pgdg10)
               geos37 = 3.7.2-1.rhel7
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest



These all lead me to think that my libraries have gone haywire. Originally all of the PostgreSQL and PostGIS software was built from source but then I believe some were installed by the yum package manager.

Any assistance would be greatly appreciated!

--
________________________________
Phil Hurvitz
Research Scientist @ CSDE<https://csde.washington.edu>
Contact information<http://staff.washington.edu/phurvitz/contact>
Calendar<http://staff.washington.edu/phurvitz/calendar/>
________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200106/0dd38892/attachment.html>