The fresh installation process fails with a Table does not exist error, whenever trying to insert data into the correctly created tables.
The user has been assigned appropriate privileges and the test has been executed with superuser priveledges as well.
It seems like a ruby issue using the postgresql search_path setting as it works correctly if the tables happen to be in the public schema.
I don't know that much ruby, or have used activerecord so I can't provide a patch.. sorry.
Table rules_categories does not exist
from /root/sonar-1.9/war/sonar-web/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/base.rb:2839:in `attributes_from_column_definition'
from /root/sonar-1.9/war/sonar-web/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition_with_lock'
from /root/sonar-1.9/war/sonar-web/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/base.rb:2279:in `initialize'
from /root/sonar-1.9/war/sonar-web/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/base.rb:691:in `create'
from /root/sonar-1.9/war/sonar-web/WEB-INF/config/../lib/../db/migrate//003_populate_database.rb:33:in `insert_rule_categories'
from /root/sonar-1.9/war/sonar-web/WEB-INF/config/../lib/../db/migrate//003_populate_database.rb:22:in `up'
from /root/sonar-1.9/war/sonar-web/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/migration.rb:280:in `migrate'
from file:/root/sonar-1.9/war/sonar-web/WEB-INF/lib/jruby-complete-1.2.0.jar!/benchmark.rb:293:in `measure'
... 17 levels...
from file:/root/sonar-1.9/war/sonar-web/WEB-INF/lib/jruby-rack-0.9.4.jar!/rack/builder.rb:29:in `instance_eval'
from file:/root/sonar-1.9/war/sonar-web/WEB-INF/lib/jruby-rack-0.9.4.jar!/rack/builder.rb:29:in `initialize'
from <script>:2