Disabled dataset in GDB with postgres

Question

First, I installed postgres and ArcGis pro, them I put the st_geometry.dll in the lib of postgresql, and finally I created my data base in postgresql, and connected this in Arcgis Pro. After that, I created spatial type for my SDE user. With stack builder I installed postgresql, but the option of create spatial database presented error.

But, when i tryed to create a dataset, this process failed.

Version postgres: 9.6

Version Arcgis pro: 2.5

Captura_.PNG

Captura.PNG

George Thompson · Answer

Ok, you can use Postgres and have limited functionality without enabling the Enterprise Geodatabase portion. Feature Datasets are considered advanced functionality within the Geodatabase. You cannot edit non-registered database tables (spatial or non-spatial) from ArcGIS Pro or other clients. All the editing/updating/creation of features would need to be done outside ArcGIS Pro.

Here is some documentation:

Databases and ArcGIS – Databases and ArcGIS—Help | Documentation

DBMS data types supported in ArcGIS (Postgres) - DBMS data types supported in ArcGIS—Help | Documentation

Postgres data types supported in ArcGIS - PostgreSQL data types supported in ArcGIS—Manage geodatabases in PostgreSQL | Documentation

Also make sure to have the Postgres and PostGIS at a supported version - PostgreSQL database requirements for ArcGIS 10.8 and ArcGIS Pro 2.5—System Requirements | Documentation

Luisa_FernandaSantana_Callejas · Answer

No, I don't have Enterprise, only Arcgis Online

George Thompson · Answer

Did you run the Create or Enable Enterprise Geodatabase GP tool at any point?

Create a geodatabase in PostgreSQL on Windows—Manage geodatabases in PostgreSQL | Documentation

Based on your description, it looks like you only enabled the ST spatial type and NOT geodatabase functionality.