I'm learning OpenACS, and had to install PostgreSQL to support it. There are great instructions by Marc Liyanage here, as well as a StartupItem so that Postgres will launch on boot.
On the #openacs irc weblog I also posted a link to my own version of the StartupItem.