ArcGIS Pro

Create an on-premises PostGIS only geodatabase in PostgreSQL

If you only require a PostGIS spatial data type, use the new Spatial Type parameter on the Create Enterprise Geodatabase geoprocessing tool when you create a geodatabase in PostgreSQL. If you specify PostGIS for the Spatial Type, you don’t have to configure the ST_Geometry type.

The Spatial Type parameter is available starting with ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1 for use with on-premises PostgreSQL databases.

The Create Enterprise Geodatabase includes a Spatial Type option to create a geodatabase in PostgreSQL that uses only PostGIS.
Choose PostGIS for the Spatial Type.

In earlier ArcGIS versions, geodatabase system tables in on-premises PostgreSQL databases required the ST_Geometry spatial type. So even if you used a PostGIS spatial type in your feature classes, you still had to configure the ST_Geometry library to create a geodatabase in PostgreSQL.

By removing the ST_Geometry requirement, ArcGIS can support on-premises PostgreSQL databases that cannot use the ST_Geometry type, such as EDB Postgres Advanced Server.

Additionally, when a geodatabase contains only the PostGIS type, you can use third-party tools to migrate it to a PostgreSQL-based database service offering in the cloud. That means moving your geodatabase will be easier if you later decide to migrate your ArcGIS deployment to the cloud.

About the author

I work with several product teams at Esri to test user experiences and translate developer-speak into English.

Notify of
Inline Feedbacks
View all comments

Next Article

End-to-end spatial data science 5: Machine learning: Cluster analysis in Python and ArcGIS

Read this article