I've come to the conclusion that Twisted is too complex to bother with. Not to mention they can't decide on a templating language.

Other than that, I've only used Zope. I concur with your dislike of the repository.

Webware is OK if you like the whole JSP thing.

As far as Postgres goes, just avoid the Zope drivers. Which, if you avoid Zope as well, shouldn't be an issue. ;-)