Did you look at http://www.atlassian.com/software/jira/
- can use postgresql as database
- free to open source projects, used by apache, hiberate, OpenSymphony
- bugs may be submitted via email/web
- built-in configurable workflow
- runs as J2EE webapp on a number of OS's
- lots of other features
I am not associated with the company, just a user.