ERROR
An error similar to the following is reported in the $SDEHOME/etc/sde_setup.log.
“[Fri Apr 3 09:23:20 2009] ST_GEOMETRY support being installed... [Fri Apr 3 09:23:21 2009] ev.SQLstate = 58P01 SDE DBMS Error: -51 ERROR: could not access file "st_geometry": No such file or directory"
The ST_GEOMETRY library files need to be copied.
Code:
ls -l /usr/lib/st_geometry.so /usr/lib/libpe.so /usr/lib/libsg.so
-r-xr-xr-x 1 root root 1878411 2009-04-01 08:54 /usr/lib/libpe.so
-r-xr-xr-x 1 root root 375528 2009-04-01 08:55 /usr/lib/libsg.so
-r-xr-xr-x 1 root root 205170 2009-04-01 08:55 /usr/lib/st_geometry.so
Code:
dynamic_library_path = '/opt/PostgreSQL/8.3.0/lib:$libdir'
Code:
postgres=# SELECT pg_reload_conf(); pg_reload_conf
t (1 row)
postgres=# SELECT current_setting('dynamic_library_path'); current_setting
/usr/lib (1 row)
Get help from ArcGIS experts
Download the Esri Support App