Blogger.create { :name =>'Matt Aimonetti',
:location => 'San Diego, Ca',
:email => mattaimonetti AT gmail.com,
:linkedin => Matt's Linkedin page,
:recommend_me => HERE,
:contractor => true}

Installing PostgreSQL on Mac

Written by matt on May 9th, 2007

I'm working on a Rails project and I need to make sure that our code is compatible with PostgreSQL. I never installed/used before and since I'm lazy and rely on other people knowledge, I decided to install Postgresql using MacPort.

It was actually simpler than I expected. I simply followed this post and almost everything went ok.

sudo port install postgresql81 +server

will install postgresql 

sudo gem install postgres -- --with-pgsql-include-dir=/opt/local/include/postgresql81 --with-pgsql-lib-dir=/opt/local/lib/postgresql81

Will do a gem install

Start your server automatically by doing:

sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql81-server.plist
sudo launchctl start org.macports.postgresql81-server

Create a folder for your dbs mkdir /opt/local/var/db/pgsql/data

Add pgsql to your path (I use textmate)

mate ~/.profile

My path looks like that:

export PATH=/opt/local/bin:/opt/local/sbin:/opt/local/apache2/bin:/opt/local/lib/postgresql81/bin/:$PATH

export PGDATA="/opt/local/var/db/pgsql/data"

restart your shell (or open a new tab) and type initdb -D /opt/local/var/db/pgsql/data

Success. You can now start the database server using:

postmaster -D /opt/local/var/db/pgsql/data

or pg_ctl -D /opt/local/var/db/pgsql/data -l logfile start

Now, create your db: $ createdb test -E utf8 or drop your newly created db: $ dropdb test

That's it, it was easy.

more info from apple

Social Bookmark Button

Tags:

0 comments


Post a comment