[update] PostgreSQL Problems in Leopard When Using MacPorts

(update): scroll to the bottom of this posts for an update.

It is not possible to compile the current PostgreSQL package in Macports using Leopard. The following error occurs:

gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -L../../src/port -L/opt/local/lib  -L/opt/local/lib   access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o executor/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/SUBSYS.o rewrite/SUBSYS.o storage/SUBSYS.o cop/SUBSYS.o utils/SUBSYS.o 
../../src/timezone/SUBSYS.o ../../src/port/libpgport_srv.a -lssl -lcrypto -lm -o postgres 
Undefined symbols: 
  "_PlannerInitPlan", referenced from: 
      _PlannerInitPlan$non_lazy_ptr in SUBSYS.o 
  "_strtable", referenced from: 
      _strtable$non_lazy_ptr in SUBSYS.o 
  "_base_yytext", referenced from: 
      _base_yytext$non_lazy_ptr in SUBSYS.o 
  "_PrivateRefCount", referenced from: 
      _PrivateRefCount$non_lazy_ptr in SUBSYS.o
ld: symbol(s) not found 
collect2: ld returned 1 exit status 
gnumake[2]: *** [postgres] Error 1 
gnumake[1]: *** [all] Error 2 
gnumake: *** [all] Error 2 
Error: Target org.macports.build returned: shell command " cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_postgresql82/work/postgresql-8.2.5" && gnumake " returned error 2 

I solved this by downloading the original package from the PostgreSQL website. After that just untar the package, copy over the source and start the compilation again:

$ port install postgresql82 # Error occurs 
$ cd  /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_postgresql82/work/postgresql-8.2.5
$ tar xjvf postgresql-8.2.5.tar.bz2 # (the downloaded package)
$ cp -rf postgresql-8.2.5/src/* src/
$ port install postgresql82 postgresql82-server

Setup PostgreSQL:

$ mkdir -p /opt/local/var/db/postgresql82/defaultdb
$ chown postgres:postgres /opt/local/var/db/postgresql82/defaultdb
$ su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'
$ launchctl load -w /Library/LaunchDaemons/org.macports.postgresql82-server.plist

Hopefully the package maintainer will create a new package soon. In the mean time use this as fix.

UPDATE: the corresponding ticket of this bug can be found here
Also if you want to compile PostgreSQL with DTrace support take a look here

UPDATE 2: It seems grady.vincent found an easier solution. Thanks Chris for the notice! Here it is:

sudo port clean postgresql82
sudo port configure postgresql82
cd /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_postgresql82/work/postgresql-8.2.5
make
sudo port install postgresql82
sudo port install postgresql82-server