installing postgres on os x lion w/ brew

gistfile1.txt

#install postgres
brew install postgres

#setup postgres db dir
initdb -D /usr/local/var/postgres #init the database

#set postgres to load automatically && start postgres
mkdir -p ~/Library/LaunchAgents
cp /usr/local/Cellar/postgresql/9.1.2/org.postgresql.postgres.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/org.postgresql.postgres.plist

#and your'e off!
psql template1 

#to make a new database
CREATE ROLE smoke_signal with Password 'yourpassword'
CREATE DATABASE SmokeSignal with owner = smoke_signal;