PostGIS

This document describes the process for installing PostGIS and creating a template PostGIS database. It is assumed that PostgreSQL has been installed. If it hasn't, please refer to the PostgreSQL page.

Installing PostGIS

Install PostGIS.

$ su
$ pacman -Sy postgis

Creating a Template PostGIS Database

Become the postgres user.

$ su
$ su - postgres

If you haven't created a superuser for accessing PostgreSQL, you may want do that now. You will be prompted for granting permissions to that user.

$ createuser [username]

Create a new database called "template_postgis" ("-E UTF-8" optional).

$ createdb -O [username] template_postgis -E UTF-8

PostGIS requires the pl/pgSQL language to be installed on a database.

$ createlang plpgsql template_postgis

Load the PostGIS spatial types for PostgreSQL and spatial reference systems. "lwpostgis.sql" and "spatial_ref_sys.sql" are part of the installation of PostGIS, and may reside somewhere else besides "/usr/share" depending on the installation.