I've been running a production site(
http://www.triadbusiness.com) with OpenACS+PostgreSQL for over four months with no DB problems. The site normally handles a few thousand hits per day. Both AOLserver and PostgreSQL have been running for a number of weeks without restart.