ArcGIS Pro V 3.5.1 ST_Geometry version supported

Question

Hello. I am working on installing PostgreSQL and successfully using it on my ArcGIS Pro. I am using ArcGIS Pro version 3.5.1, and I also downloaded the ArcGIS Pro ST_geometry Library (PostgreSQL). The challenge I am encountering is that I do not know the version of ST_Geometry supported by ArcGIS Pro 3.5.1. I will need this information so that I can copy that .dll file to my Postgres V 15.13 file.

I will appreciate any clues to help.

DanPatterson · Accepted Answer

Upgrade the ST_Geometry type in a PostgreSQL database—ArcGIS Pro | Documentation

says

Download a new version of the st_geometry library from My Esri.

I don't use it, so you will have to check

George_Thompson · Accepted Answer

Make sure you select the folder that says "15" then the OS of the PostgreSQL instance is installed on (Windows / Linux).

It is not needed if using RDS or similar instance in cloud

syedinzamam · Accepted Answer

You're close! For ArcGIS Pro 3.5.1 with PostgreSQL 15.13, the supported ST_Geometry version is 5.0.0. You’ll find the .dll in the DatabaseSupport\PostgreSQL folder inside your ArcGIS Pro install directory — just match it to your Postgres version.

Also, I’ve shared some useful GIS resources (including free tools) here if you're interested:
https://cartogeek.com/free-gis-software/

Hope that helps!

George_Thompson · Accepted Answer

Ok, so you create the PostgreSQL database (non-Enterprise GDB) outside of ArcGIS Pro. That can be done in pgadmin.

It looks like you are using the "template" database that is created with the PostGIS install.

You need to create a new database in PostgreSQL. There are MANY different ways to do this.

Here is how I do it in pgadmin: you must be logged in as the admin account (in my case is postgres)

1. Right Click the PostgreSQL instance name --> Create --> Database

2. provide a name and leave the owner as "postgres"

On the "Definition" tab, you use the "postgis_35_sample" database as the template. You can also set a tablespace location, if desired.

Then hit save.

3. In ArcGIS Pro, make a connection to that new DB and create a new FC, just call it test.

I usually create a database user, using the GP tool in Pro: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-user.htm, and have that user own the data.

Hope this helps clear up any confusion.