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.
Solved! Go to Solution.
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
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
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!
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
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
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!
Thank you, everyone. Your clues were so helpful. I completed the installations and was able to create and connect the database in ArcGIS Pro; however, I was unable to create a feature class. I had copied the right PostGIS file and ensured it was installed and operational on Postgres. My question is this: Is it possible to use this database on ArcGIS Pro, being that it is not an Enterprise database?
I have attached a screenshot of the error messages that appear everytime i try to create a feature class. Suggestions that will help me on this will be deeply appreciated. Thank you.
If you have not enabled the "Enterprise Geodatabase", you do not need to use that GP tool. You can just copy / paste another FC into the database or you can right click the database connection and hit "New" --> "Feature Class" and create it that way.
Make sure that you have PostGIS enabled also.
Thank you, @George_Thompson. I did enable PostGIS. According to the study guide, I am required to create a database first. I want to do this in ArcGIS Pro, but I keep being pointed to creating an Enterprise database, and I do not want to go through that route. I was able to connect to a default database, but I still cannot create a feature class in it. I did the copy and paste of an existing FC, which you suggested, and the same error occured. So the key issue is that the schema called 'postgres' does not exist. the existing schema is 'public'. see screenshot below.
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.