[postgis-users] Greetings / Alternative compile instructions for PostGIS

[Rob Cermak]

PostGIS is now in use in Fairbanks, Alaska.

MapServer using PostGIS:
  * Mapserver 4.6
  * Postgres 8.0.1
  * Postgis 1.0.2
  * Mandrake 10.2

Site may move, but for now using the itasca template example:
http://ak.aoos.org/mapserver/aoos/

Had help from "Mapping Hacks" to import Tiger line data for Alaska:
  Layers = Railroads, Roads, Coastline
  Takes a bit to render, not the cleanest dataset in the world

Those looking for some alternative instructions to enable PostGIS on a
system that utilizes the rpm package manager and you want to use the
native binary installed with your system:

* Install GEOS and PROJ software libraries
* Install the RPM source package for the postgres binary you are using
  * This will populate /usr/src/RPM area (or some other area...)

* cd /usr/src/RPM/SPECS
* rpmbuild -bc postgresql.spec
  * load any dependent development packages requested
  * this will unpack the source, patch it and build.  It will not
    reinstall over your existing installation.

* cd /usr/src/RPM/BUILD/postgres-{version}/contrib
* unpack postgis-{version}
* cd postgis-{version}
* Edit: Makefile.config {enable PROJ and GEOS}
* make
* make install
  * this will install the PostGIS needed items to appropriate places
  * make note of where it stashed the lwpostgis.sql and 
    spatial_ref_sys.sql files, you will need them later.
    They are also in the root of the postgis install tree.

You are done.  You will may/need to repeat this process if there are
updates to postgres package in the future.

If you want to enable GDAL with the postgis system, you can then point
GDAL when rebuilding to:
  /usr/src/RPM/BUILD/postgres-{version}/contrib/postgis-{version}

Cheers!
-- 
Rob Cermak : 907-474-7948 : FAX 907-474-7204 : PGP = 0x75869A6E
Alaska Ocean Observing System : Data Management 
School of Fisheries and Ocean Sciences : University of Alaska Fairbanks
cermak at sfos.uaf.edu : fnjrc1 at uaf.edu
ED9U1M7P01 at alaska.edu : cermak at alaska.edu