How To Install PostgreSQL Using Brew On OSX
Posted by Weston Ganger
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: