Create Enterprise Geodatabase Error.. Error connecting to database as geodatabase admin.

Question

I am trying to create first enterprise geodatabase in PostgreSQL. this error occurs. What should I do?

Below the error:

Error connecting to database as geodatabase admin.

Executing: CreateEnterpriseGeodatabase PostgreSQL (IP Adress) MyData DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** # "keycodes"
Start Time: Tue May 28 13:03:52 2019
User has privileges required to create database objects.
Geodatabase admin user created.
Database created.
Error connecting to database as geodatabase admin
Failed to execute (CreateEnterpriseGeodatabase).
Failed at Tue May 28 13:04:10 2019 (Elapsed Time: 17.88 seconds)

Thanks for the help in advance.

George_Thompson · Answer

What is the version of Postgres that you are using?

Here are the supported Postgres versions for 10.2.x; https://resources.arcgis.com/en/help/system-requirements/10.2/#/PostgreSQL_Database_Requirements/015100000075000000/

I would HIGHLY recommend moving to at least 10.7 or use ArcGIS Pro 2.3.3 (latest version).

PriyaAggarwal1 · Answer

Hi Thompson,

I'm using ArcMap 10.2.2.

When I run Create EGDB tool for making EGDB in postgreSQL, than a SDE user and schema is auto created in postgreSQL but this SDE connection is not becoming geodatabase administrator.

I move st_geometry.dll file to C:\Program Files\PostgreSQL\10\lib, but still postgres is not creating Geo database.

I am not sure about the issue, may be its postgres or arcmap version compatibility issue.

George_Thompson · Answer

Are you using ArcGIS Pro or ArcMap/ArcCatalog for the GP tool?

Can you try to name the GDB in all lower-case; https://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-postgresql/setup-geodatabase-postgresql-windows.htm?

Have you followed the steps in the above help for creating the EGDB within Postgres?

Geodatabase‌