You should take a look at this thread: https://openacs.org/forums/message-view?message_id=3804765
If you ask me I would OpenACS IS NOT compatible with PostgreSQL 8.4 yet.