I think I had to do that when I dumped and restored my database. It looks like some things where exported in an order that causes problems with openacs.
Also which version of postgresql are you using?