For tsearch2:
http://www.postgresql.org/docs/9.0/static/tsearch2.html
These upgrade directions are ambiguous for anyone, such as myself, who hasn't worked with tsearch2 internals etc.
Looks like OpenACS is going to need some kind of recipe/script to convert to pg9. :/