$ brew install postgresql
Do the launchctl stuff that Homebrew says to do.
$ initdb /usr/local/var/postgres
$ createdb whateverthehell
$ psql whateverthehell
# CREATE USER ethan;
# GRANT ALL PRIVILEGES ON DATABASE whateverthehell
If you're using Rails, specify the host in the database.yml file.