I am running PostGIS on Linux Mint 17.2 using versions in ubuntugis-unstable PPA. I recently updated from
2.2.2+dfsg-2~trusty0. Using soft upgrade instructions http://postgis.net/docs/postgis_installation.html#soft_upgrade_extensions I tried:
ALTER EXTENSION postgis UPDATE TO "2.2.2";
However, the result is:
ERROR: could not access file "$libdir/postgis-2.2": No such file or directory
$ pg_config --libdir /usr/lib $ pg_config --pkglibdir /usr/lib/postgresql/9.3/lib
Neither location has a
postgis-2.2 folder. Extension control files and upgrade scripts (such as
postgis--2.1.4--2.2.2.sql) are in
/usr/share/postgresql/9.3/extension. Additionally, I have a
/usr/share/postgresql/9.3/contrib/postgis-2.2 folder which has the
postgis_upgrade.sql file, which is littered with references to
$libdir/postgis-2.2. Presumably this is the script that gets called by the
ALTER EXTENSION statement, triggering the "no such" error.
How can I correctly do a soft upgrade? I am trying to avoid doing a dump and reload of the data.