I have switched all of our development servers to Postgres 9.2, using OpenACS head. There are a number for 9.2 features we really want to start using, like range types, as well as significant performance improvements. We haven't had any issues with OpenACS core packages on PG 9.2. The only other packages we have used are acs-developer-support, acs-events, and acs-datetime