[postgis-users] undefined symbol: sqlite3_column_table_name

[Doug Niven]

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