The PostgreSQL formula for homebrew has already been updated to version 9.

Thankfully, with a little help from google, I found Adam Vandenberg’s 8.4 formula.

brew update
brew install
http://github.com/adamv/homebrew/raw/versions/Library/Formula/postgresql8.rb