To toggle between full slide deck and individual, use the
s key to see the slide notes.
These instructions apply to all the slides we'll be posting. Best experienced with Firefox or Chrome.
Covered here: http://postgis.net/install, but we'll repeat a bit.
Compile from source, of course.
The road may be hard and bumpy, but the reward is great.
Quickest and Newbie friendly http://postgresapp.com
Homebrew seems to be another popular option http://braumeister.org/formula/postgis
Downloads and instructions here: http://postgis.net/windows_downloads
RedHat EL, CentOS, Scientific Linux, Amazon Linux: Use PostgreSQL Yum repo: http://yum.postgresql.org
Some instructions you might find useful: An almost Idiot's guide to Installing PostgreSQL 9.3, PostGIS 2.1, and pgRouting with Yum
Contains PostgreSQL, PostGIS, GeoServer, QGIS, OpenLayers, OpenLayers templates.
Create a database if you don't have one already. No postgres database does not count, and please don't install PostGIS in postgres.
CREATE DATABASE presentation;
If your distribution did not come with raster or running with lower than PostgreSQL 9.1, Sorry, can't use
CREATE EXTENSION. Go here
Connect to your database first and then run the below commands
CREATE EXTENSION postgis; CREATE EXTENSION fuzzystrmatch; CREATE EXTENSION postgis_tiger_geocoder; CREATE EXTENSION postgis_topology;
Other extensions commonly used or packaged with PostGIS
CREATE EXTENSION pgrouting; -- You'll see these more in PostGIS 2.2 CREATE EXTENSION postgis_sfcgal; CREATE EXTENSION address_standardizer; CREATE EXTENSION pointcloud; CREATE EXTENSION pointcloud_postgis;
Connect to your database first preferably using psql and then run the following scripts which are usually located in /share/contrib/postgis-2.1 of your postgresql install.
\i postgis.sql \i spatial_ref_sys.sql -- if you happen to have raster and want it \i rtpostgis.sql
For tiger geocoder, run the correct scripts Tiger geocoder install without extensions.
POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER
SELECT * FROM pgr_version();
version | tag | build | hash | branch | boost ---------+--------+-------+---------+--------+-------- 2.0.0 | v2.0.0 | 3 | fbbaa2a | master | 1.54.0