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
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.
No, I don't have Enterprise, only Arcgis Online
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...