Hi Folks, I'm a sysadmin not a PostGIS expert, but am hoping the following issue may be something this group can advise on.
User who's experiencing this said "I then decided to try to write the raster files into the database on the server directly myself in a second schema, just to see if that fixed the problem. None of my raster files could be written into the database- I get the same error as below." ERROR: could not load library "/usr/pgsql-11/lib/postgis_raster-3.so": /usr/gdal31/lib/libgdal.so.27: undefined symbol: sqlite3_column_table_name SQL state: XX000 I saw a previous user had said this might be related to sqlite3 lacking a compile flag, so I rebuilt sqlite3 with that per: https://stackoverflow.com/questions/48169718/libgdal-so-1-undefined-symbol-sqlite3-column-table-name Sqlite3 version 3.32.3 And within Postgres: # SELECT PostGIS_Full_Version(); post gis_full_version ------------ POSTGIS="3.0.2 2fb2a18" [EXTENSION] PGSQL="110" GEOS="3.8.1-CAPI-1.13.3" SFCGAL="1.3.1" PROJ="7.1.1" GDAL="GD AL 3.1.3, released 2020/09/01" LIBXML="2.9.1" LIBJSON="0.11" LIBPROTOBUF="1.0.2" WAGYU="0.4.3 (Internal)" TOPO LOGY RASTER (1 row) Any ideas, suggestions most appreciated! Doug _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
