Forum OpenACS Q&A: Response to OpenACS 4 on Mac OS X (and Darwin) HOWTO now available
I've fixed the paths in the install README - thanks for pointing that out.
The important part of the aolserver log is where 40-db-query-dispatcher-procs.tcl gets sourced and db_qd_load_query_file is meant to be getting defined. If you search in the error log you should find a section like
Notice: tcl: enabling .tcl pages
Notice: Loading OpenACS, rooted at /usr/local/web/openacs4
Notice: Sourcing /usr/local/web/openacs4/packages/acs- bootstrap-installer/bootstrap.tcl
Notice: Database API: The following pools are available: subquery main log
Notice: dbdrv: opening database 'postgres:localhost::openacs4'
Do you see any error messages between the "Sourcing /usr/..." and "Database API: ..." lines?