Here’s the fastest possible way to get PostgreSQL up and running on OS X Tiger (come to think of it, this might be the fastest way to install PSQL period).

Link: PostgreSQL Database Server

An added bonus, the current build installs version 8.1.3, which is compiled as a universal binary and runs natively on Intel Macs.