Select to view content in your preferred language

Disabled dataset in GDB with postgres

1060
3
02-18-2020 05:04 AM
Luisa_FernandaSantana_Callejas
New Contributor

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 

0 Kudos
3 Replies
George_Thompson
Esri Notable Contributor

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.

--- George T.
0 Kudos
Luisa_FernandaSantana_Callejas
New Contributor

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

0 Kudos
George_Thompson
Esri Notable Contributor

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 | Documentat... 

--- George T.
0 Kudos