[GIS] “Create Enterprise Geodatabase” errors

Question

I am trying to use " Create Enterprise Geodatabase" option in arcmap 10.1:

I am getting two following errors:

You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.

and

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

I have put C:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\Linux64\st_geometry.so in /var/lib/pgsql/9.2 directory.

Answer 1

You need to play close attention to version numbers when installing support libraries. You are placing the Esri PostgreSQL 9.0 library in PG 9.2 -- this will not work. In fact, PostgreSQL 9.2 support was not introduced until ArcGIS 10.2, so there isn't any way to connect an ArcGIS 10.1 client to PG 9.2.