How to enable PostGIS in database (Linux Lubuntu / OSGeo)

If you are running PostgreSQL 9.1+, you don’t need to bother with the template database. Just create a database and then on the SQL view in pgAdmin, type and run:

CREATE EXTENSION IF NOT EXISTS postgis;
CREATE EXTENSION IF NOT EXISTS postgis_topology;

That will spatially enable your database.




Leave a Reply

Your email address will not be published. Required fields are marked *