mhares

error generated when trying to create a geodatabase in PostgreSQL 9.2

Discussion created by mhares on Oct 30, 2013
Latest reply on Nov 1, 2013 by mhares
I am using the 'Create Enterprise Geodatabase' option in ArcMap 10.2 to create a geodatabase in a PostgreSQL 9.2 database. I have followed the instructions for installing the PostGreSQL client libs and i can connect to the database OK).
I have also copied the st_geometry.dll lib from the <ARGGIS_HOME>\DatrabaseSupport\PostgreSQL\9.2\windows64 directory to the <POSTGRESQL_HOME>\lib directory.
I have also restarted the PostgreSQL server.

However, i still get the following message when creating the geodatabase

Executing: CreateEnterpriseGeodatabase PostgreSQL dmsmulticlient test DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** # "C:\Program Files (x86)\ESRI\License10.2\sysgen\keycodes"
Start Time: Wed Oct 30 12:37:42 2013
User has privileges required to create database objects.
Geodatabase admin user already exists.
Database already exists.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
You must copy the latest ST_GEOMETRY and dependent libraries 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 (CreateEnterpriseGeodatabase).
Failed at Wed Oct 30 12:37:43 2013 (Elapsed Time: 1.34 seconds)



Have i missed any steps? What am i doing wrong?

Thanks
Mike

Outcomes