topic Re: Import data to postgresql in arcgis pro in ArcGIS Pro Questions

Import data to postgresql in arcgis pro

sevinc4maps — Thu, 30 May 2024 08:27:11 GMT

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

Re: Import data to postgresql in arcgis pro

George_Thompson — Thu, 30 May 2024 10:16:43 GMT

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?

Re: Import data to postgresql in arcgis pro

sevinc4maps — Thu, 30 May 2024 10:53:34 GMT

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?

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

-- No, how can I do it?

Re: Import data to postgresql in arcgis pro

George_Thompson — Thu, 30 May 2024 13:07:31 GMT

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

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

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-postgresql-windows.htm

"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-postgresql.htm

Seems like something is not configured correctly....