Setting up PostGres on a Mac

PostGres SetUp

After first installing the Enterprise DB installer, which caused massive headaches and problems, and cost me roughly one lost day, I finally had the wisdom to try the homebrew installer - http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x.  This worked great.  

After downloading and installing, PostGres, you need to get the server running.  The best way to do this is to put it in the automatic running of your Bash Profile.  To do this, add the following line to your Bash Profile (you can do this using sudo vi /etc/profile.  /etc):

the two lines, 

PATH=/Library/PostGreSQL/9.3/bin:$PATH

export PATH

 

To check if postgres is running, in terminal type 

ps auxwww | grep postgres

 

Then you must remember… to run rake db:create and rake db:migrate!  Otherwise it will show a PostGres error…

| Back

Footerfull