Installing Postgresql

install-pg.markdown

#Installing PostgreSQL#

##Drag-and-Drop Install##

• Download Postgres.app
• Drag to Applications folder and double-click

##Full-Beard Install##

• Update homebrew:
  • $ brew update
• Install formula:
  • $ brew install postgresql
• Initialize database:
  • $ initdb /usr/local/var/postgresql
• Set Postgres to run automatically on startup:
  • $ ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
• Alternately, you can run Postgres manuaally (not reccomended):
  • $ postgres -D /usr/local/var/postgres