I am running Create Enterprise GeoDatabase tool on PostgreSQL Database on windows ,this tool is throwing above error
What is the version of PostgreSQL? PostgreSQL database requirements for ArcGIS 10.4.x
I am using Postgres 9.4.11(64bit) , PostGIS 2.3.2 (64bit) , ArcGIS 10.4 ..
Windows 8 64Bit OS.
Hi Signal Group team - Thanks for asking your questions and welcome to the GeoNet community! I wanted to let you know that we're moving your question to the Managing Data space so our Esri and user subject matter experts can further help answer this and future questions. So you're aware on how and where to post your questions, here's a few quick tips and reminders:
Thanks again for contributing and I hope this helps and let us know if you have any questions.
Geodatabase for a wider audience.
It's always critical to specify, in the question:
The error message implies that your database is incompatible with your Desktop.
Well from the System Requirements page PostgreSQL database requirements for ArcGIS 10.4.x—System Requirements | ArcGIS Desktop , it seems that the PostGIS 2.3.2 is not supported with 10.4.x yet.
Can you try with PostGIS 2.2 and check...
Thanks for Solution .
It is working now ..One Problem is that we should connect the DB using SDE User ,then run this particular tool on that connection ,it works.
That is because the PostgreSQL Enterprise Geodatabase System Table needs to be created under the SDE Schema.
Create a geodatabase in PostgreSQL on Windows—Help | ArcGIS Desktop
Check the "Create a geodatabase" part in the above link..
Amazon RDS Postgres Enable Gerodatabase tool with Postgis 2.2.5
I am getting below error any help is appreciated.
Start Time: Fri Jun 23 06:39:09 2017Validated authorization file.User has required privileges for geodatabase setup.XML support is enabled for the database instance.Connected RDBMS instance is setup for Esri spatial type configuration.Failed to create stored procedures in the geodatabase. Error (-42) DBMS error code: -42ERROR: too many parameters specified for RAISECONTEXT: compilation of PL/pgSQL function "sde_layer_def_change_table_name" near line 20SQL state: 42601
See the setup log in the following location for additional error information:C:\Users\ADMINI~1\AppData\Local\Temp\2\sde_setup.logCould not create geodatabase tables and stored procedures.Failed to execute (EnableEnterpriseGeodatabase).Failed at Fri Jun 23 06:39:34 2017 (Elapsed Time: 25.13 seconds)
Please ask a new question instead of adding on to an existing thread with a different environment. As stated in this thread, it's always critical to specify, in the question, the exact release of the database to which you are connecting.
Retrieving data ...