[postgis-users] PostGIS raster library problem

[Regina Obe]

Philip,

 

By the looks of the error – your .so issue is whatever version of GEOS  gdal was compiled with is newer than the version of geos you have loaded.

 

Which version of PostGIS are you running and which version of PostgreSQL?

 

DO 

 

SELECT version() ,  postgis_full_version();

 

The above should tell you which version of GEOS you are using and also the vintage of your PostGIS.

 

You may need to upgrade GEOS or recompile GDAL with a lower GEOS.

 

Thanks,

Regina

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Philip M. Hurvitz
Sent: Monday, January 6, 2020 3:36 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] PostGIS raster library problem

 

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/20200108/e52fb910/attachment.html>