st_geometry.so issue

gongjing

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

Asrujit_SenGupta

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