Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

1012
8
Jump to solution
06-23-2017 08:47 AM
Highlighted
New Contributor II

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

0 Kudos
1 Solution

Accepted Solutions
Highlighted
Esri Frequent Contributor
8 Replies
Highlighted
Esri Frequent Contributor
Highlighted
New Contributor II

Hi George Thompson

Thanks for your reply, We will try with 9.4.5 Postgres 

Venkat

0 Kudos
Highlighted
New Contributor II

Hi George ,

Is AWS aurora with Postgres  work with  Geodatabase.

Thanks

Venkat

0 Kudos
Highlighted
Esri Frequent Contributor

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 ... 

--- George T.
0 Kudos
Highlighted
Esri Esteemed Contributor

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

0 Kudos
Highlighted
New Contributor II

Hi Vince Angelo

Thank you for your clarification

Venkat

0 Kudos
Highlighted
Esri Esteemed Contributor

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

- V

Highlighted
New Contributor II

George Thompson

Thank you Venkat