topic Creating PostgreSQL geodatabase from Pro 2.2 in ArcGIS Pro Questions

Creating PostgreSQL geodatabase from Pro 2.2

MinShin — Tue, 17 Jul 2018 23:58:38 GMT

Hi,

I am trying to create geodatabase in ArcGIS Pro(v2.2) using PostgreSQL(v9.6) with PostGIS(v2.3) and getting this error.

"You must copy the latest ST_GEOMETRY library to the PostgreSQL software location. Refer to the ArcGIS help topics for more details."

I found st_geometry.dll from

C:\Program Files\ArcGIS\Server\DatabaseSupport\PostgreSQL\9.6\Windows64
C:\Program Files\ArcGIS\DataStore\framework\runtime\pgsql\lib
C:\Program Files (x86)\ArcGIS\Desktop10.6\DatabaseSupport\PostgreSQL\9.6\Windows64

None of them worked when I copied lib to C:\Program Files\PostgreSQL\9.6\lib. I keep getting the same error.

"You must copy the latest ST_GEOMETRY library to the PostgreSQL software location. Refer to the ArcGIS help topics for more details."

Do I need to copy PostgreSQL client files mentioned in ArcGIS Help here.? If so, what are those files? Should I copy everything in there?

The testdb is created at least.

Any help please?

Thanks.

Min

arcgis pro 2.x postgresql 9.6‌ enterprise-geodatabase‌

Asrujit_SenGupta — Wed, 18 Jul 2018 03:50:45 GMT

You were following the instructions for creating a geodatabase using ArcGIS Desktop. That DLL was for ArcGIS Desktop. Instead check this: Create a geodatabase in PostgreSQL on Windows—Manage geodatabases in PostgreSQL | ArcGIS Desktop

Check the "Place the st_geometry.dll file" part in the link...

MinShin — Sat, 21 Jul 2018 08:34:15 GMT

Hi Asrujit,

Thanks for your reply. I downloaded "ArcGIS Pro Database Support" package from My Esri. Indeed, the "latest" ST_Geometry library fixed the issue.

Asrujit_SenGupta — Sat, 21 Jul 2018 08:37:08 GMT

Glad to help. Please close the Thread by marking the appropriate response as Correct.

FrancescoGiovinazzo — Mon, 01 Apr 2019 15:00:29 GMT

Perfect answer, the documentation should be updated