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!