"Create Enterprise Geodatabase" errors

Question

I am trying to use " Create Enterprise Geodatabase" option in arcmap 10.1:

I am getting two following errors:

You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.

and

Connected RDBMS instance is not setup for Esri spatial type configuration. Failed to execute

I have put C:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport\PostgreSQL\Linux64\st_geometry.so in /var/lib/pgsql/9.2 directory.

You mention two errors and then ask 2-3 questions. To better fit our Q&A format, my recommendation is to edit your question to focus on what is most important for you to know first. I suspect that is encapsulated in your last paragraph. Once you know that, you'll be better placed to decide whether the errors remain relevant. — PolyGeo
– PolyGeo ♦, Commented Sep 2, 2013 at 3:35

Vince · Accepted Answer · 2013-09-02 13:26:22Z

3

You need to play close attention to version numbers when installing support libraries. You are placing the Esri PostgreSQL 9.0 library in PG 9.2 -- this will not work. In fact, PostgreSQL 9.2 support was not introduced until ArcGIS 10.2, so there isn't any way to connect an ArcGIS 10.1 client to PG 9.2.

answered Sep 2, 2013 at 13:26

Vince

20.5k16 gold badges49 silver badges65 bronze badges

Andre Silva · Accepted Answer · 2013-09-02 14:05:34Z

2

Have you checked the Esri step-by-step tutorial on how to setup the PostgreSQL and ArcGIS?

I have also had a discussion with Esri analysts here, worth checking

Andre Silva

10.5k12 gold badges57 silver badges109 bronze badges

answered Sep 2, 2013 at 7:22

Alex Tereshenkov

30k4 gold badges55 silver badges119 bronze badges

2 Answers 2