Just for the record, I used the instructions from Vinod, except that I am using PostgreSQL 7.4:
% psql -V
psql (PostgreSQL) 7.4
It works fine with AOLserver 4, OpenACS-HEAD on Panther (on a powerbook G4). I will try in the New Year to get the same on an Xserve and Mac OS X 10.3 server. Hopefully everything will compile smoothly ;).
