Select to view content in your preferred language

st_geometry.so issue

1549
3
04-15-2019 10:53 AM
gongjing
New Contributor

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!!

0 Kudos
3 Replies
George_Thompson
Esri Notable Contributor

What client version of ArcGIS are you using to run this tool?

Here is a list of supported O/S's for the latest Pro and ArcMap release. I also do NOT see your OS listed; https://pro.arcgis.com/en/pro-app/help/data/databases/database-requirements-postgresql.htm

--- George T.
0 Kudos
gongjing
New Contributor

thanks for your reply. My client is ArcGIS Desktop 10.5.

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

PostgreSQL 9.4.2 is not a supported database version for ArcGIS 10.5.x.

Minimum supported database versions

The following versions of PostgreSQL and PostGIS are supported with ArcGIS. The specific versions listed are the minimum minor version supported and certified for each supported major release of PostgreSQL. Newer minor versions are supported, but are not certified.

  • PostgreSQL 9.5.3 (64 bit)
    • PostGIS 2.2
  • PostgreSQL 9.4.8 (64 bit)
    • PostGIS 2.2
  • PostgreSQL 9.3.13 (64 bit)
    • PostGIS 2.2
0 Kudos