Postgresql Stuff

gistfile1.txt

rails new <name of app> -d postgresql
rails g scaffold User name:string
rake db:migrate

Install Postgres.app
brew install postgresql

Problem: FATAL: role "<name of app/db here>" does not exist
Solution: 
  cd /usr/lib
  createuser -s -r postgresql #first time only
  createuser -s -r <name of app/db> #example: createuser -s -r codetalk_development

Start PG CLI:
psql -h localhost
CREATE DATABASE your_database_name; (should return "CREATE DATABASE") #example: codetalk_development

For creating users in psql:
http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/