Redmine

The reqirements documentation
http://www.redmine.org/wiki/redmine/RedmineInstall#Requirements
for Remdine 1.0 should mention that you need version 0.6.3 of postgres-pr.

Using postgres-pr-0.6.1 gives you:

# rake --trace db:migrate:upgrade_plugin_migrations RAILS_ENV=production 
(in /local/ups/prd/redmine/v1_0)
** Invoke db:migrate:upgrade_plugin_migrations (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted!
undefined method `quote_ident' for PGconn:Class
/local/ups/prd/redmine/v1_0/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:440:in `quote_column_name'
/local/ups/prd/redmine/v1_0/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:217:in `quoted_left_column_name'
/local/ups/prd/redmine/v1_0/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:93:in `acts_as_nested_set'
...