AnsweredAssumed Answered

st_geometry.so issue

Question asked by agon1012 on Apr 15, 2019
Latest reply on Apr 16, 2019 by asrujit_pb

Hi,

    I am using postgresql9.4.2 for linux and want to create spatial type in db.I have put st_geometory.so in postgresql's library directory.But when create spatial type,there is a error that is 

"You must copy the latest ST_GEOMETRY library to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.

Connected RDBMS instance is not setup for Esri spatial type configuration.
Failed to execute".

    And I find a error log that is "ERROR:  could not load library "/home/gpadmin/gpdb/lib/postgresql/st_geometry.so": /home/gpadmin/gpdb/lib/postgresql/st_geometry.so: undefined symbol: Float8GetDatum (dfmgr.c:240)".so I test command  ld -v st_geometry.so, show result like this:

ld: warning: cannot find entry symbol _start; not setting start address
st_geometry.so: undefined reference to `elog_finish'
st_geometry.so: undefined reference to `pstrdup'
st_geometry.so: undefined reference to `pq_getmsgbytes'
st_geometry.so: undefined reference to `errstart'
st_geometry.so: undefined reference to `SPI_tuptable'
st_geometry.so: undefined reference to `pfree'
st_geometry.so: undefined reference to `get_attstatsslot'
st_geometry.so: undefined reference to `CurrentMemoryContext'
st_geometry.so: undefined reference to `ReleaseSysCache'
st_geometry.so: undefined reference to `SPI_fname'
st_geometry.so: undefined reference to `errfinish'
st_geometry.so: undefined reference to `dlsym'
st_geometry.so: undefined reference to `SearchSysCache'
st_geometry.so: undefined reference to `Float8GetDatum'
st_geometry.so: undefined reference to `elog_start'
st_geometry.so: undefined reference to `SPI_execute_with_args'
st_geometry.so: undefined reference to `SPI_getvalue'
st_geometry.so: undefined reference to `pq_endtypsend'
st_geometry.so: undefined reference to `SPI_finish'
st_geometry.so: undefined reference to `list_nth'
st_geometry.so: undefined reference to `SPI_connect'
st_geometry.so: undefined reference to `repalloc'
st_geometry.so: undefined reference to `pq_begintypsend'
st_geometry.so: undefined reference to `errmsg'
st_geometry.so: undefined reference to `free_attstatsslot'
st_geometry.so: undefined reference to `DatumGetFloat8'
st_geometry.so: undefined reference to `pg_qsort'
st_geometry.so: undefined reference to `pq_sendbytes'
st_geometry.so: undefined reference to `palloc'
st_geometry.so: undefined reference to `errcode'
st_geometry.so: undefined reference to `pq_copymsgbytes'
st_geometry.so: undefined reference to `SPI_exec'
st_geometry.so: undefined reference to `SPI_processed'
st_geometry.so: undefined reference to `default_statistics_target'
st_geometry.so: undefined reference to `DirectFunctionCall1Coll'
st_geometry.so: undefined reference to `dlopen'
st_geometry.so: undefined reference to `DirectFunctionCall2Coll'
st_geometry.so: undefined reference to `errhint'
st_geometry.so: undefined reference to `pg_detoast_datum'
st_geometry.so: undefined reference to `vacuum_delay_point'
st_geometry.so: undefined reference to `dlclose'
st_geometry.so: undefined reference to `MemoryContextAlloc'

 

 Is the file of st_geometry.so not compatible for my system?My OS is centos 7 1611.

 how to fix it?Thanks!!

Outcomes