Fresh install of postgres 9.2 with hstore and postgis 2.0.1

gistfile1.txt

brew install postgres
brew install postgis (might need a pip install numpy - make sure you're not in a venv)
initdb /usr/local/var/postgres -E utf8
createdb template_postgis
psql -f /usr/local/share/postgis/postgis.sql template_postgis
psql -f /usr/local/share/postgis/spatial_ref_sys.sql template_postgis
createuser -sP [new user]
createdb -T template_postgis -O [new user] [new database]
psql [new database] [new user]
create extension hstore;
create extension intarray;
create extension unaccent;
alter function unaccent(text) immutable;