Forum OpenACS Q&A: Response to Help diagnosing Postgres/AOLserver "freezing" problem

I was having problems with Postgres hanging -- specifically, the DB transactions on some pages were not being executed on the initial page load (reloading the pages caused the DB transactions to execute and the data to appear).

I resolved the issue by upgrading from Postgres 7.0 to 7.1 (for help upgrading, see http://pascal.scheffers.net/openacs/pgupdate/).