PostGIS broken after Ubuntu 16.04 upgrade

Question

I upgraded Ubuntu from 15.01 to 16.04 and PostGIS is broken. Below are the errors:

psql (9.5.2)
Type "help" for help.

osm=# select version();
version                                           
-------------------------------------------------------------------------------------------------
 PostgreSQL 9.5.2 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit
(1 row)

osm=# \dx
                                      List of installed extensions<br>
   Name    | Version |   Schema   |                             Description                             
-----------+---------+------------+---------------------------------------------------------------------
 hstore    | 1.3     | public     | data type for storing sets of (key, value) pairs
 pgrouting | 2.1.0   | public     | pgRouting Extension
 plpgsql   | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis   | 2.2.2   | public     | PostGIS geometry, geography, and raster spatial types and functions
(4 rows)

osm=# select postgis_full_version();
ERROR:  could not load library "/usr/lib/postgresql/9.5/lib/postgis-2.2.so": /usr/lib/postgresql/9.5/lib/postgis-2.2.so: undefined symbol: lwgeom_sfcgal_version
CONTEXT:  SQL statement "SELECT postgis_lib_version()"
PL/pgSQL function postgis_full_version() line 22 at SQL statement

This database had PostGIS working before the upgrade. I tried create extension postgis; on a new database and got the same error. I also tried to remove and install PostGIS again but to no avail.

Answer 1

Rebuilding from source worked for me also.

The problem wasn't realy system upgrade. Simply, creating extensions such as postgis_topology or postgis_tiger_geocoder threw exactly the same error.

I advise also restarting postgresql service after rebuilding, just in case. Or better :
-stop the service; -rebuild; -start again the service;

And it might be worth adding sudo ldconfig at the end :

./configure
make

_{in case you want to test the build prior installing :}

make test

_{and then}

sudo make install
sudo ldconfig

Answer 2

Rebuilding postgis-2.2.2 from the source solved the problem, using the default build steps:

./configure
make
make install

Answer 3

This solved this issue for me (it says 14.04 but solved for 16.04):

PostGIS non functional on Ubuntu 14.04