Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

[venkateswarlunittala]

Hi GIS Experts,

Any help is appreciated.

Following these instructions

Create a geodatabase on Amazon Relational Database Service for PostgreSQL—ArcGIS for Server (10.4) |... 

PostgreSQL 9.6.2  Amazon RDS

PostGIS 2.3.2 (64bit)

ArcGIS 10.4.1

Enable Enterprise Geodatabase gives below error

Start Time: Fri Jun 23 06:39:09 2017
Validated 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: -42
ERROR: too many parameters specified for RAISE
CONTEXT: compilation of PL/pgSQL function "sde_layer_def_change_table_name" near line 20
SQL state: 42601

See the setup log in the following location for additional error information:
C:\Users\ADMINI~1\AppData\Local\Temp\2\sde_setup.log
Could 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)

Thanks

Venkat

[George_Thompson · Accepted solution]

It looks like you are not on a support PostgreSQL version: PostgreSQL database requirements for ArcGIS 10.4.x—Help | ArcGIS Desktop 

The highest support version is 9.4.5, not 9.6.x

Also review this GeoNet post: https://community.esri.com/message/650241-re-solved-amazon-postgresql-rds-enable-enterprise-geodatab... 

https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=d763a900-aac0-499a-ac50-1...‌

[venkateswarlunittala]

Hi George Thompson

Thanks for your reply, We will try with 9.4.5 Postgres 

Venkat

[venkateswarlunittala]

Hi George ,

Is AWS aurora with Postgres  work with  Geodatabase.

Thanks

Venkat

[George_Thompson]

I am not familiar with AWS Aurora and Geodatabase functionality. i would review this link: Geodatabases in PostgreSQL included with ArcGIS Enterprise on Amazon Web Services—ArcGIS Enterprise ... 

[VinceAngelo]

Any of the PG 9.4.x releases (where x >= 5) are supported with ArcGIS 10.4.1. Only 9.4.5 was certified.

[venkateswarlunittala]

Hi Vince Angelo

Thank you for your clarification

Venkat

[VinceAngelo]

Please use the "Mark Correct", "Helpful", and "Like" buttons in lieu of adding records to the database with thanks.

- V

[venkateswarlunittala]

George Thompson

Thank you Venkat

[johanwatt]

AWS RDS with PostgreSQL 9.6.2

The latest version of PostGIS is 2.3.2 (64-bit)

ArcGIS 10.4.1

When I enable Enterprise Geodatabase, I receive the following error message

Start Time: Friday, June 23, 2017, at 06:39:09
The authorization file has been validated.
The user has the necessary privileges in order to set up the geodatabase.
It has been enabled for the database instance to support XML.
The RDBMS instance that is connected to Esri spatial type configuration is already configured.
A stored procedure could not be created in the geodatabase due to an error. The error code is (42); the error code is (42);
The DBMS error code for this error is -42.
ERROR: there are too many parameters specified for the RAISE command.
CONTEXT: Compilation of the PL/PgSQL function "sde_layer_def_change_table_name" near line 20 of the file
The SQL state at the moment is 42601.

Additional error information can be found in the setup log at the following location:
C:\Users\ADMINI~1\AppData\Local\Temp\2\sde_setup.log
The geodatabase tables and stored procedures could not be created.
The command (EnableEnterpriseGeodatabase) could not be executed.
The request failed on Fri Jun 23 06:39:34 2017 (Elapsed Time: 25.13 seconds)

Thanks