[GIS] ArcSDE installation with PostgreSQL (error – 1015)

arcgis-serverenterprise-geodatabasepostgresql

I am trying to install ArcSDE for Postgresql on CentOS 5.5 in i686 architecture. I have successfully installed and configured Postgresql. I did SDE pre-installation and as ArcSDE user, run the ArcSDE 10 installation script that went well without any error. During post-installation, while running $SDEHOME/bin/sdesetup, I am getting error 1015. The log file is showing SDE DBMS Error and is unable to install ST_GEOMETRY. I can see that st_geometry.so is created in /sdeexe100/pg841_st_lib/ directory. I am confused if I missed something during installation/configuration process or if I have to copy st_geometry.so file somewhere else for the installation. I have attached my log file.

Any help is highly appreciated!

Mukesh

Best Answer

OK Here is some bad news, CentOS is not a support installation for ArcGIS Server Basic (ArcSDE). BUT since the base of CentOS is RHEL it "SHOULD" be fine

http://resources.arcgis.com/content/arcsde/10.0/postgresql-system-requirements

OK so now let's look at the issue, the an Esri Forum I have used in the past points to a couple of things

http://forums.arcgis.com/threads/19369-sde-postgresql-multiple-databases-problem

  • st_geometry.so needs to be present in: SDEHOME/bin location
  • PG/ lib location - where ever your LD_LIBRARY Path is pointing to for the postgres user, that location will depend on the Postgres version and how it was installed.

If that doesn't work keep reading the post as there iare some other dbinit settings you can change and lastly check the logs to see if the plpgsql is installed correctly

Have Fun,

CDB

Related Question