1

I have a PostGIS database that we use for data storage. I would like to open this data in ArcMap instead of storing it in another format.

In previous versions of ArcMap it has been possible to open data from PostGIS with varying combinations of ArcGIS and PostgreSQL as supported by ESRI.

I now have a PostgreSQL 9.3 database (v9.3.3, also another one which is v9.3.4) with PostGIS v2.1.1 installed.

In previous versions of ArcGIS I have been able to view PostGIS data. I haven't enabled ESRI geodatabse or anything on my database, it is a normal PostGIS database.

I upgraded to ArcGIS 10.3 and ArcMap will not open PostGIS layers.

ESRI state that with ArcGIS 10.3 the required files for using PostreSQL/PostGIS are included as standard.

I have checked that the dll files included with ArcGIS are indeed 32 bit in C:\Program Files (x86)\ArcGIS\Desktop10.3 (since ArcMap, ArcCatalog etc are 32 bit you need the 32 bit files) and they are. ArcGIS Pro installs with the 64 bit version in C:\Program Files\ArcGIS Pro.

I cannot find very much information on this hence the question here.

Anyone had any success with ArcGIS 10.3 (ArcMap not Pro) and opening PostGIS data? I am going to upgrade my database to PostgreSQL 9.3.5 since ESRI state that as the supported version (ESRI website), to check this isn't the reason for the error. Other than that I am out of ideas seeing as I do not get a helpful error message. The error message is as below:

enter image description here

closed as off-topic by PolyGeo Nov 1 '16 at 0:02

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – PolyGeo
If this question can be reworded to fit the rules in the help center, please edit the question.

  • I have changed it now. – James S Jan 20 '15 at 8:12
  • 1
    What exact error are you receiving? Did you add the appropriate PG version directory to your system PATH? – Vince Jan 20 '15 at 11:47
  • I have added a screenshot of the error message. @Vince do you have a link to the documentation that mentions adding PG version directory to system path? – James S Jan 20 '15 at 11:55
  • 1
    This is a bit like calling your mechanic and saying your car won't start, then when he asks you to describe the problem, you fax him a picture of a car wrapped around a tree. An application panic is not best described with "will not open PostGIS layers." This is an issue to address with Esri Tech Support, since it's likely to hinge on some characteristic of your environment. I had no difficulty connecting to both 9.2 and 9.1 PG instances without setting the PATH, so they're doing something tricky under the hood to allow connection under regular circumstances. – Vince Jan 20 '15 at 13:53
  • See also gis.stackexchange.com/questions/140978/… – Stefan Apr 6 '15 at 11:37