Import data to postgresql in arcgis pro

sevinc4maps

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

George_Thompson

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.

sevinc4maps

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?

George_Thompson

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.