Select to view content in your preferred language

Import data to postgresql in arcgis pro

222
3
3 weeks ago
sevinc4maps
New Contributor II

I connected with Postgresql in Arcgis Pro. But I cannot import data. I looked for ways on how to import it, but no solution worked.

I also downloaded st_geometry.dll

sevinc4maps_0-1717057540976.png 

sevinc4maps_1-1717057582770.png

 

 

 

Tags (1)
0 Kudos
3 Replies
George_Thompson
Esri Frequent Contributor

Can you provide the version of PostgreSQL / PostGIS and ArcGIS Pro being used?

What version of the st_geometry.dll are you using?

                 What version did you download and what was the folder name?

Did you create a data owner to load the data or a PG superuser account?

--- George T.
0 Kudos
sevinc4maps
New Contributor II

Can you provide the version of PostgreSQL / PostGIS and ArcGIS Pro being used?

-- postgresql 15, arcgis pro 3.3

What version of the st_geometry.dll are you using?

sevinc4maps_0-1717065909536.png

 Did you create a data owner to load the data or a PG superuser account?

-- No, how can I do it?

0 Kudos
George_Thompson
Esri Frequent Contributor

Are you running at least PostgreSQL 15.5, the min. supported version: https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql...

For the ST_ spatial type, did you review this doc: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/stgeometry-postgre...

Did you put the file in the "lib" folder?

Did you restart the PostgreSQL service once you installed the ST_ file?

You also need the following: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/setup-geodatabase-...

"The st_geometry.dll requires the Microsoft Visual C++ Redistributable Package (x64). See PostgreSQL database requirements for the package version required. If this package is not present on the PostgreSQL server, download it from the Microsoft site and install it."

 

 

To create a database user (that can own objects) review this doc: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/add-users-postgres...

Seems like something is not configured correctly....

--- George T.
0 Kudos