you have to change a few configuration parameters in postgresql.conf to activate backward compatibility.
See: http://www.openacs.org/xowiki/en/How_to_install_in_Postgres_8%2ex
I use OpenACS with 8.2
