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
