topic Disabled dataset in GDB with postgres in ArcGIS Pro Questions

Disabled dataset in GDB with postgres

Luisa_FernandaSantana_Callejas — Tue, 18 Feb 2020 13:04:38 GMT

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

Re: Disabled dataset in GDB with postgres

George_Thompson — Thu, 20 Feb 2020 12:18:08 GMT

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.

Re: Disabled dataset in GDB with postgres

Luisa_FernandaSantana_Callejas — Thu, 20 Feb 2020 12:49:17 GMT

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

Re: Disabled dataset in GDB with postgres

George_Thompson — Thu, 20 Feb 2020 14:45:50 GMT

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