Installing PostgreSQL 8.2.5 on Leopard

This one is for takizo, who seems to be way too busy to even watch ManU games with me these days.

Postgresql installation on Leopard via Macports seems to b0rk. I found a solution here and here. Both instructions, which I summarized here will install Postgresql flawlessly, with Dtrace support. Here goes:

First of all, you might want to try:


sudo port -v selfupdate
sudo port -v install postgresql82 postgresql82-server


just in case the port tree has been updated and the problem has been fixed. If not:


cd ~/Downloads
wget http://ftp3.jp.postgresql.org/pub/db/postgresql//source/v8.2.5/postgresql-8.2.5.tar.bz2
cd /opt/local/var/macports/build/opt_local_var_macports_sources_rsync.macports.org_release_ports_databases
postgresql82/work/postgresql-8.2.5
sudo make clean
sudo make distclean
sudo tar xjvf ~/Downloads/postgresql-8.2.5.tar.bz2
sudo cp -rf postgresql-8.2.5/src/* src/

Next, before you do anything, apply the patch for dtrace:

cd ~/Downloads
wget http://leenux.org.uk/wp-content/uploads/2007/10/postgresql-825-fixosxdtracediff.gz
cd -
cat ~/Downloads/cat postgresql-8.2.5-fixosxdtrace.diff | patch -p1

After patching is done, proceed to run configure:

sudo ./configure --sysconfdir=/opt/local/etc/postgresql82 \
--bindir=/opt/local/lib/postgresql82/bin \
--libdir=/opt/local/lib/postgresql82 \
--includedir=/opt/local/include/postgresql82 \
--datadir=/opt/local/share/postgresql82 \
--mandir=/opt/local/share/man --without-docdir \
--with-includes=/opt/local/include \
--with-libraries=/opt/local/lib \
--with-openssl \
--with-bonjour --with-readline --with-zlib \
--enable-thread-safety --enable-integer-datetimes \
--enable-dtrace

and then:

sudo make
sudo port -v install postgresql82 postgresql82-server

And should be kau tim! Next, let's setup PostgreSQL:

sudo mkdir -p /opt/local/var/db/postgresql82/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql82/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'

And register it with launchd

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

Kau tim!

OK, word-ttmf-press munge the display - you can get the ASCII version (yes takizo, you) here