The ever-awesome @mattt has released Postgres.app. From the README:
Postgres.app is the easiest way to get started with PostgreSQL on the Mac. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down.
Even with homebrew, installing postgres can kind of be a pain sometimes. I’m always for any project that makes software installation even easier.