<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Hi all, and happy new year!</p>
<p>I'm having problems with pg_dump, and "yum update".</p>
<p>My dump is failing at the point where a raster is being dumped:</p>
<pre>...
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
</pre>
<p>If I try to select a value from that raster I get the same error:</p>
<pre>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
</pre>
<p>And when attempting an update:</p>
<pre># 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
</pre>
<p>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.</p>
<p>Any assistance would be greatly appreciated!</p>
<div class="moz-signature">-- <br>
<hr>
Phil Hurvitz<br>
Research Scientist @ <a href="https://csde.washington.edu">CSDE</a><br>
<a href="http://staff.washington.edu/phurvitz/contact">Contact information</a><br>
<a href="http://staff.washington.edu/phurvitz/calendar/">Calendar</a><a><br>
<hr>
</a></div>
</body>
</html>