I have followed Esri's ArcGIS 10.5 documentation multiple times over: http://desktop.arcgis.com/en/arcmap/10.5/manage-data/gdbs-in-postgresql/setup-geodatabase-postgresql-windows.htm
Every time I try to Create a Spatial type for the database utilizing the ST_Geometry.dll that is for pgsql 9.5 placed in the appropriate associated directory, I get the following error:
"You must copy the latest ST_GEOMETRY library to the PostgreSQL software location. Refer to the ArcGIS help topics for more details. Connected RDBMS instance is not setup for Esri Spatial type configuration. Failed to execute (CreateSpatialType)."
I get the same error if I try the enable Geodatabase tool as well.
I am pretty certain there is an issue with esri's ST_Geometry.dll and the BigSQL installation of Postgres, either the type of PostgreSQL installation or because the geodatabase tools are looking for a Postgres install in Program Files and Big SQL installs directly to C:.
Has anyone experienced this and/or know of a solution? I would really prefer to use the BigSQL implementation if possible, but it doesn't seem like it is going to work. In the mean time, I'm going to test with different installs/install locations.