topic PostgreSQL License - STGeometry Extension in ArcGIS Enterprise Questions

PostgreSQL License - STGeometry Extension

denniszammarchi — Thu, 15 Jan 2026 11:23:09 GMT

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!

Re: PostgreSQL License - STGeometry Extension

George_Thompson — Thu, 15 Jan 2026 12:30:51 GMT

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-enterprise.htm), 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-postgresql-database.htm (details about it in PostgreSQL - https://pro.arcgis.com/en/pro-app/latest/help/data/databases/overview-database-spatial-types.htm#ESRI_SECTION1_A53013704BF74AFA97F85D9F0E1772F1)

Hope this helps!

Re: PostgreSQL License - STGeometry Extension

denniszammarchi — Fri, 16 Jan 2026 09:14:37 GMT

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

Have a nice day!

--- Dennis

Re: PostgreSQL License - STGeometry Extension

George_Thompson — Fri, 16 Jan 2026 20:26:12 GMT

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?

Re: PostgreSQL License - STGeometry Extension

denniszammarchi — Thu, 22 Jan 2026 08:49:56 GMT

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!

Re: PostgreSQL License - STGeometry Extension

George_Thompson — Thu, 22 Jan 2026 11:26:30 GMT

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