I have a hibernate config set to postgres and an empty xwiki database.
I verified that it works with PhenoTips v1.3.7, but when I tried it on v1.4-rc-1 I get these errors on start:
I can use v1.3.7, so not a major issue for me.
It seems that a column cannot be named "user" in postgresql. I'll fix that.
Can you try using the attached class file in your test 1.4-rc-1 (or rc-2) instance?
copy the file into /path/to/phenotips/WEB-INF/classes/org/phenotips/security/audit/ (you need to create this directory, make sure the entire path is correct)
check that it correctly starts
go to Administration -> Security -> Access logs and check that the table does contain a few entries