- brew install postgres
- initdb /usr/local/var/postgres
- postgres -D /usr/local/var/postgres
follow instructions here (don't use LaunchAgent): http://www.peerassembly.com/2011/08/09/installing-postgresql-on-lion/
- sudo chown $USER /var/pgsql_socket/
- createuser -a -d _postgres
apply this fix (source: http://nextmarvel.net/blog/2011/09/brew-install-postgresql-on-os-x-lion): curl http://nextmarvel.net/blog/downloads/fixBrewLionPostgres.sh | sh
start Postgres with: postgres -D /usr/local/var/postgres -k /tmp