ThomasG77 edited this page Dec 27, 2011 · 3 revisions
Clone this wiki locally

Mac PostGIS / Postgres Setup

After you have installed PostgreSQL and PostGIS you will need to perform further setup before you can begin to use them with mapnik.

  • Setup for Binaries/Frameworks from
  • Add the bin and man page directories to your path (assumes bash shell which is default on 10.5). You may create or append the ~/.profile with the following:
    export PATH=/usr/local/pgsql/bin:$PATH
    export MANPATH=/usr/local/pgsql/man:$MANPATH
  • Register your changes
   $ source ~/.profile

You should now be able to type the following from any directory and see the man page.

    $ man psql
  • Create a database. The installer you used from automatically created a Mac OS user on your system named postgres. Use that user to create a new database user/role and setup the database. (change "gisuser" to your liking)
    $ sudo -u postgres -i
    $ createuser gisuser
    $ createdb -E UTF8 -O gisuser mapnik
    $ createlang plpgsql mapnik
  • Alternatively you can run all commands from your normal shell user but use the '-U' flag to call them as the postgres user:
    $ createdb -E UTF8 -U postgres <dbname>
    $ createlang plpgsql -U postgres <dbname>
  • PostGIS support must be enabled for each database that requires its usage. This is done by feeding the lwpostgis.sql (the enabler script) file to the target database.
    $ psql -d mapnik -f /usr/local/pgsql/share/lwpostgis.sql
    $ psql -d mapnik -f /usr/local/pgsql/share/spatial_ref_sys.sql
    $ echo "ALTER TABLE geometry_columns OWNER TO gisuser; ALTER TABLE spatial_ref_sys OWNER TO gisuser;"  | psql -d mapnik

At this point your database should be setup to create a PostGIS table. TODO - full example showing PostGIS use.