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
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
the DLL. The location of the DLL varies (not always in PGHOME\lib), depending
on how the binaries were built. Where did you obtain your server installation media?
You mist also copy 32-bit PostgreSQL client DLLs into the Desktop/Server
<ARGGIS_HOME>\bin directory.
- V