Title: PostgreSQL - PostGIS compatibility issues
Slug: postgresql-postgis-compatibility-issues
Date: 2014-04-03 20:38:01
Author: Kartones
Lang: en
Tags: Development, PostgreSQL, Databases, PostGIS, Troubleshooting
Description: Compatibility issues encountered when updating from PostgreSQL 9.1 to PostgreSQL 9.3 with PostGIS 2.0 installed, and a solution.

 <p>Few days ago I wanted to update from PostgreSQL 9.1 to PostgreSQL 9.3, an action that initially should be easy (famous last words ;) <br>As I had also installed PostGIS 2.0, of course this ended in problems and errors. Luckily, I was able to find the solution after a lot of searching around the net and error-based trials, so let's see if this helps anybody.</p> <p> </p> <p>First of all, if after updating PostgreSQL you try to recompile and reinstall PostGIS 2.0, you will probably get a similar error in the "make install" step:</p> <p><font face="Courier New">ERROR:  could not load library [...] undefined symbol: GETSTRUCT</font></p> <p>What this error really tries to say is "your PostGIS version is outdated for this PostgreSQL version, please update".</p> <p>Basically, PostgreSQL 9.3 requires PostGIS 2.1 (I installed 2.1.1).</p> <p> </p> <p>And because history tends to repeat itself, there is a very handy compatibility chart between both software pieces at <a href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS">the PostGIS wiki</a>.</p>