I am trying to create GDBs in postgres for ArcGIS Enterprise. While the tool starts properly, it seems to get stuck at 9% .
When I look into my postgres server connection I can see that the gdb was still created.
I wouldn't care if there would be a way of terminating the progress but the only way to stop it (to be able to continue with the work I was doing...) is to "kill" the task in the task manager and to open the project again. And that is annoying...
Does anybody else have a similar problem?
I saw this post https://community.esri.com/thread/232476-arcgis-pro-create-enterprise-gdb-fails-in-postgres but (as much as I understand the issue) this does not apply to my problem.
I am using ArcGIS Pro 2.4.1 on ArcGIS Enterprise 10.7 on Ubuntu with Postgres 10.
This is how far it goes:
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.
Connected RDBMS instance is setup for Esri spatial type configuration.
When I try to create the gdb from ArcMap 10.7 then I get following error:
Executing: CreateEnterpriseGeodatabase PostgreSQL 10.10.91.25 bio_indicators DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** #
***** [this is were the link to the key code is]
Start Time: Thu Sep 26 11:58:34 2019
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 Thu Sep 26 11:58:40 2019 (Elapsed Time: 6.09 seconds)
but even this gdb is created eventually. But I cannot import any data into it as far as I tried.
I confirmed that the st_geometry.so is in the right place - what else can I do?