Select to view content in your preferred language

Error: When Creating Enterprise Geodatabase

2662
2
Jump to solution
05-13-2013 10:55 PM
MohamedRajah
Deactivated User
I am trying to create Enterprise Geodatabase in PostgreSQL. I was following ArcGIS Help 10.1 [HTML]http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_geodatabase_in_PostgreSQL/002... I have installed PostgreSQL 9.2.4 (64bit), ArcGIS Server 10.1 (64bit) and ArcGIS Desktop 10.1(32bit) in the same computer. I have copied correct bit version of PostgreSQL client libraries in both ArcGIS Server and ArcGIS Desktop. Similarly I copied the ST_geometry into PostgreSQL lib folder. After doing everything I am getting following error message. Is it because of using PostgreSQL 9.2.4 Can anyone help me to resolve the issue.

Executing: CreateEnterpriseGeodatabase PostgreSQL localhost test123 DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** # "C:\Program Files\ESRI\License10.1\sysgen\keycodes"
Start Time: Tue May 14 10:42:25 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 Tue May 14 10:42:27 2013 (Elapsed Time: 2.00 seconds)
0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
Esri Esteemed Contributor
ArcGIS 10.1 only comes with PG 9.0.x and 9.1.x ST_GEOMETRY libraries.
PostgreSQL 9.2.x is not yet supported.

- V

View solution in original post

0 Kudos
2 Replies
MarcoBoeringa
MVP Alum
Can't say if this is the issue, but you're not working on the officially supported release with 9.2.4. Higher release numbers may, or may not, work. Usually, it is best to stick with the ESRI recommended environments.

See this Help page:
PostgreSQL database requirements for ArcGIS 10.1
0 Kudos
VinceAngelo
Esri Esteemed Contributor
ArcGIS 10.1 only comes with PG 9.0.x and 9.1.x ST_GEOMETRY libraries.
PostgreSQL 9.2.x is not yet supported.

- V
0 Kudos