Everyone deserves some quick copy & paste action for their system setup.
Here a quick setup for PostgreSQL on OSX using brew
# update & install
brew update
brew install postgres
# create postgres db
postgres -D /usr/local/var/postgres
create your username db
createdb `whoami`
# login to using your user account for first time
psql
# Start Automatically on System Starup
mkdir -p ~/Library/LaunchAgents
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
# Optional: Install AdminPack for PgAdmin
psql postgres -c 'CREATE EXTENSION "adminpack";'
Now your rockin with PostgreSQL!
Related External Links: