I'm trying to connect ArcGIS Desktop 10.1 to PostGreSQL/PostGIS tables. I have PostGreSQL 9.2/PostGIS 2.0, which was installed with the latest OpenGeo suite. Unfortunately ArcGIS direct connections to PostGres are only supported by ESRI for version 9.1.3. Would it be possible to downgrade my version of PostGres 9.2 to 9.1.3 while maintaining the other up-to-date components of the OpenGeo Suite (i.e. geoserver, geowebcache, etc.)?
There is no need to do this. You can download the drivers and successfully access a PostgreSQL 9.2 database from ArcGIS 10.1
Please see the following link: ArcGIS 10.1: Setting up a connection to PostgreSQL
In order to connect ArcGIS Desktop 10.1, you will need to use the
pg_client_windows86 set of drivers. These are the 32 bit drivers. Place the files from this set into the
bin directory of your ArcGIS Desktop installation.
The same drivers may be used if you have ArcReader and wish to have a direct database connection used in a
.pmf configuration file.
Once you have done this, you will be able to create a connection to the database like the one seen here:
You will know the connection is working in two ways:
- There will be no error messages
- The list of available databases on that server will show up in the pulldown at the bottom
As proof, here is a screenshot of the database version information from pgAdmin III:
To answer the downgrade question it really depends on what OS you installed on. If on ubuntu it is possible to install multiple versions of postgresql in parallel without the need to downgrade. So you could install postgresql-9.1 from the postgresql repositories and be able to run that without affecting the 9.2 version that was installed as part of opengeo suite.
You will have to transfer any data over manually and change configuration to avoid things like port conflicts, etc...