Installing postgis on mac

gistfile1.sh

# installation commands
brew update
brew install postgresql
brew install postgis

# start the server
postgres -D /usr/local/var/postgres

# setup commands
createdb <name>
createuser --interactive <username>

# interactive cmd line tool for querying etc
psql

# once in psql...
# lists all databases
\list
# switch dbs
\connect <dbname>
# lists all tables in the current database
\dt 

# database needs to have postgis extension installed
-- Enable PostGIS (includes raster)
CREATE EXTENSION postgis;
-- Enable Topology
CREATE EXTENSION postgis_topology;
-- fuzzy matching needed for Tiger
CREATE EXTENSION fuzzystrmatch;
-- Enable US Tiger Geocoder
CREATE EXTENSION postgis_tiger_geocoder;

# useful info here: http://postgis.net/install/

# importing esri shapefiles
# I used the gui tool pgShapeLoader.app which came with the mac osx postgis installer
# http://postgresapp.com/
# for command line import, try http://suite.opengeo.org/opengeo-docs/dataadmin/pgGettingStarted/shp2pgsql.html