If you're on a Mac and don't want a menubar icon (I decided this recently), `brew install postgres`, and then write yourself some functions to make starting and stopping easier:
EnterpriseDB has a nice set of PostgreSQL installers for all platforms. It also bundles PgAdmin 3 if you need a GUI. It's not as hip as PG Commander, but it's a real client that can do pretty much anything (vs PG Commander where you can't even create a new db instance).
Postgres.app is nice when it works. When you install the latest version the psql tool it bundles and exposes in the menu assumes you have a db that matches your user name, which, of course, doesn't exist, so you can't connect to the Postgres :-)
It also doesn't work that great if you already have another version setup running on the default port.
So postgresapp.com's installer is great, but due to some xyz thingie, it limits at 27 or so connections for 9.2 (maybe still in 9.3? - haven't followed the GH issue). Startled me when I ran into that and motivated me to move to a regular install.
If you're on a Mac and don't want a menubar icon (I decided this recently), `brew install postgres`, and then write yourself some functions to make starting and stopping easier:
https://github.com/jclem/dotfiles/blob/master/zsh/functions/... https://github.com/jclem/dotfiles/blob/master/zsh/functions/...