delbetu/osx_pg_install.md

Last active April 19, 2016 23:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/delbetu/fd139f0e5cddbcec155224ce8f91fa2d.js"></script>
Save delbetu/fd139f0e5cddbcec155224ce8f91fa2d to your computer and use it in GitHub Desktop.

Download ZIP

Instructions to install postgres on mac os

Raw

osx_pg_install.md

#Postgres ##Install

brew install postgresql
brew services start postgresql
initdb /usr/local/var/postgres - create new database cluster
/usr/local/Cellar/postgresql/<version>/bin/createuser -s postgres

##To start server at startup

mkdir -p ~/Library/LaunchAgents
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

##login

psql -U postgres -h localhost