PostgreSQL on OS X
Published: February 6th, 2007It’s a little hard to install PostgreSQL on OSX, so here’s a guide you can follow!
Due to work, I had to switch to PostgreSQL for Development. I thought it would be easy at first to set up, like MySql, but wowah was I wrong.
First compiling from source kept bugging out, Fink was just odd as usual, and Darwinports was giving me fetching errors itself.
So after hours upon hours of trying to get PostgreSQL up I finally learned that you can get it through Darwinports like this:
sudo port install postgresql882 +server
Not to mention that the user permissions on PostgreSQL is very odd to work with when used to MySql. The +server part actually takes care of the permissions for you, so you don’t have to do that manually anymore.
After I finally got postgres running, I had trouble with the gem. So after getting a hint from someone you can use the ‘pure-ruby’ build.
sudo gem install postgress-pr
Ahh finally my rails enviornment can breathe Postgress.
Do I like it better than MySql? Meh, whatever works. I honestly like simplicity better, so I’d usually learn towards MySql for ease of installing and setting up a database. I feel that way for all things really, it’s the lazy inside of me. Agile things are always better :).
Ready. Set. Go.
In terms of the formatting, you're allowed to use markdown, textile, or basic html; it's truly up to you -- what strikes your fancy?
You don't have to worry about your e-mail address being sold to a russian-spam-mafia. I'm only going to use it for my own weird needs; like asking you out for a date on a lonely night of coding.