I have successfully added a raster to postgis using the following:
raster2pgsql -s 4326 -I -C -M 00N_030E.tif -F -t 250x250 -a test.00N_030E | psql -U postgres -d raster -h localhost -p 5432
I tried loading the raster into QGIS 2.14.1 to view it. However, it is listed as a table without a geometry.
This is from the QGIS message log: 2016-05-09T12:35:34 1 Field rast ignored, because of unsupported type raster
I have tried to enable all raster drivers using the following:
ALTER DATABASE raster SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
ALTER SYSTEM SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
but did not seems to work.
Any suggestions as to what the issue maybe and how to rectify it?