[postgis-users] Borked PostGIS 2.2 Upgrade

[Eloi]

On 11-08-16 06:08, Lee Hachadoorian wrote:
> Running PostGIS on PostgreSQL 9.3 Linux Mint 17.2 using
> ubuntugis-unstable PPA. I had a working PostGIS 2.1.4. I recently apt
> upgraded to PostGIS 2.2.2. I then tried:
>
>      ALTER EXTENSION postgis UPDATE TO "2.2.2";
>
> However this resulted in:
>
>      ERROR:  could not access file "$libdir/postgis-2.2": No such file
> or directory
>
I believe you missed a step of creating a symbolic link to the new 
folder with the newest version.
Make sure the folder paths are the same to you.
In Ubuntu I did like this:

sudo ln -s /usr/lib/postgresql/9.3/lib/postgis-2.2.so 
/usr/lib/postgresql/9.3/lib/postgis-2.1
sudo ldconfig
psql -d database_name -c 'ALTER EXTENSION postgis UPDATE TO "2.2.2";'

Cheers,

Eloi