PostGIS

From MapbenderWiki

PostGIS is an OSGeo project implementing Geographic Objects for PostgreSQL. Mapbender uses PostGIS functions to process geospatial data, transform coordinate systems and export data in different formats.

Using PostGIS in PostgreSQL

Recent versions of PostgreSQL have an option to include PostGIS during installation. It is recommended to use this setup for Mapbender installations.

You can also install PostGIS manually for the database <dbname> using the PostgreSQL role postgres:

createlang plpgsql <dbname>
psql -f <path to postgis.sql file> -d <dbname>
psql -f <path to spatial_ref_sys.sql file> -d <dbname>

You can automize adding the PostGIS extension to new databases by creating a postgis_template and using it as the value for parameter T in:

createdb -T postgis_template

Learn more using the PostGIS and PostgreSQL documentations.