lutraconsulting / ostranslator-ii

A graphical QGIS plugin for loading Ordnance Survey MasterMap into PostGIS.
16 stars 8 forks source link

Post-processing error #23

Closed ghost closed 7 years ago

ghost commented 7 years ago

I am getting this error. Running the query directly does work, postGIS is installed. Any ideas on what I could try?

All jobs completed successfully.

Failed to complete one or more post-processing tasks:

Post-processor error: Failed to load layer topographicarea for applying default style.

Post-processor error: function postgis_version() does not exist
LINE 1: SELECT postgis_version()
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

You opted to apply the default OS style. Please ensure you also set up SVG paths and fonts for those who will be using the layers. See http://www.lutraconsulting.co.uk/products/ostranslator-ii/ for more information.

Loaded in 0.2 hours (853 seconds).
ghost commented 7 years ago

For completeness.

postgres=# SELECT postgis_version();
            postgis_version
---------------------------------------
 2.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)
ghost commented 7 years ago

Resolved. PostGIS was not enabled on the db, or schema. One or other, I had assumed it was a global thing.