postgres on mac os x lion

jan 24 2012

While Mac OS X Lion ships with PostgreSQL Server, it's not recommended for development use as it's not possible to upgrade or modifiy it. Instead, you should install another instance of postgres using Brew.

  • brew install postgres
  • installs postgres into /usr/local/bin
  • update .bash_profile - export PATH=/usr/local/bin:$PATH
  • mkdir /usr/local/pgsql/data
  • initdb -D /usr/local/pgsql/data
  • pg_ctl -D /usr/local/pgsql/data -l logfile start (starts postgres)