topic ArcGIS Pro Create Enterprise GDB Fails in Postgres in ArcGIS Pro Questions

ArcGIS Pro Create Enterprise GDB Fails in Postgres

roemhildtg — Fri, 19 Apr 2019 18:49:35 GMT

Hey so I'm creating a new enterprise gdb using Pro 2.3.2. And the tool fails with this message:

User has privileges required to create database objects.
Geodatabase admin user already exists.
Database created.
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 library 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 Friday, April 19, 2019 1:47:20 PM (Elapsed Time: 3.14 seconds)

But the tool runs fine in ArcMap/catalog. Any tips?

Re: ArcGIS Pro Create Enterprise GDB Fails in Postgres

Robert_LeClair — Fri, 19 Apr 2019 22:13:33 GMT

Are you using ArcMap 10.6.x or earlier? And are you using PostgreSQL 10.x? If so, then you'll need to upgrade your ArcMap to 10.7 and copy the latest ST_GEOMETRY.DLL to your C:\Program Files\PostgreSQL\10\lib so that AGP 2.3.x and ArcMap 10.7.x can use the same *.dll to create the enterprise geodatabase. I saw this error when I upgraded PostgreSQL from 9.5 to 10.0. I'm now at ArcMap 10.7.0 and ArcGIS Pro 2.3.2 and can create enterprise geodatabases in both for a PostgreSQL RDBMS.

If it's not possible to upgrade your ArcMap to 10.7.0, then you can continue to create your enterprise geodatabases in ArcMap and then make database connections to them in AGP. Or downgrade to an earlier version of PostgreSQL??? Hope this helps.

Re: ArcGIS Pro Create Enterprise GDB Fails in Postgres

roemhildtg — Mon, 22 Apr 2019 16:44:17 GMT

Thanks Robert. This is the issue - we'll look into upgrading to 10.7 and use arcmap in the meantime. Thanks!