Install Problem

[angusm]

I am trying to install JOPR 2.2.1 on Windows. I have downloaded and installed PostGres 8.4. I have declared the rhq admin user and the rhq database as described in http://www.jboss.org/community/wiki/Jopr-Installation.
When I got to the "Confirm Database settings" bit on the install screen, it failed with the "Relation RHQ_Principal does not exist" as desrcribed in http://jopr.org/confluence/display/JOPR2/PostgreSQL. However after I declared the table, I got an error saying it did not have the rights to access the table. After that I got "Relation RHQ_Server does not exist".
It seems that it is insisting on having the complete db already declared.
Am I doing something stupid?

[mazz]

FWIW, http://jopr.org/confluence/display/JOPR2/Installation is better install docs than that first link you gave.

This may be caused by different behavior in Postgres 8.4 (I am not sure how much testing was performed on 8.4 on a different locales - most people are still on 8.3 I think).

Can you create you DB like that page you pointed to describes:

initdb -D /my/test/data -E SQL_ASCII --locale en_US.UTF-8

then re-install/re-run the installer and see if that fixes it?