Fixing a homebrew install of Postgres that won't start.

gistfile1.txt

sudo mkdir /var/pgsql_socket/
sudo ln -s /private/tmp/.s.PGSQL.5432 /var/pgsql_socket/

# initialize the database
initdb /usr/local/var/postgres -E utf8

# start your database
pg_ctl -D /usr/local/var/postgres/data -l logfile start

# setup a db and user for the current Mac user
createdb $USER
createuser -s -U $USER

# go create application databases
createdb app_d

# go backup a database from heroku and restore it locally.

heroku pgbackups:capture -a app --expire
curl -o ~/Downloads/app.dump `heroku pgbackups:url -a app`
pg_restore --verbose --clean --no-acl --no-owner -h localhost -d app_d ~/Downloads/app.dump