PostgreSQL License - STGeometry Extension

[denniszammarchi]

Good morning,
a user needs to create an Enterprise DB with PostgreSQL, but does not have an ArcGIS Enterprise licence. Is there a way to create the DB without losing all the Esri features for Postgre? He is not interested in creating it and using extensions such as PostGIS.

Is the ST_Geometry spatial extension only available with an ArcGIS Enterprise licence?

Best regards!

[George_Thompson]

You can enable PostGIS on the database without the required license. You will not be able to have the full functionality of an Enterprise Geodatabase (https://enterprise.arcgis.com/en/server/latest/manage-data/linux/enterprise-geodatabases-and-arcgis-...), or Esri features as you mentioned without the needed license file.

You can also install the ST_Geometry spatial type: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/add-the-st-geometry-type-to-a-postgresq... (details about it in PostgreSQL - https://pro.arcgis.com/en/pro-app/latest/help/data/databases/overview-database-spatial-types.htm#ESR...)

Hope this helps!

[denniszammarchi]

Thanks for the feedback, George!
So, do we need an Enterprise licence for ST_Geometry?

Have a nice day!

--- Dennis

[George_Thompson]

I am not 100% sure, but do not think so. Based on the doc above, it does not appear to be needed.

Just remember that it will NOT be a geodatabase if you add the ST_Geometry type. It will just add another spatial storage method.

I am not sure why you would want to have both in the database without the GDB functions.

What are you going to do with ST that you cannot do with PostGIS?

[denniszammarchi]

Because we want to know if it is possible to build a geodatabase using PostgreSQL in ArcGIS Pro Standard or Advanced (without ArcGIS Enterprise), and we are evaluating PostGIS and ST_Geometry extensions.

thank you for all the informations!

[George_Thompson · Accepted solution]

Roger, as mentioned to build an Enterprise Geodatabase (on any of the supported RDBMS's) it requires an ArcGIS Server license.