nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Find more posts tagged with

Accepted answers

George Thompson

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

All comments

George Thompson

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

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

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

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

Have a nice day!

--- Dennis

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-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!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.