ActiveRecord :: StatementInvalid：PG ::错误：错误：必须是数据库的所有者

TheFirefly 发表于 Dev

萤火虫

我是Rails的新手，尝试运行时发生了一些错误，有人bundle exec rake test:prepare问了同样的问题单击此处，我包含了psql输出。有人可以帮忙吗？谢谢你。

我遇到了错误：

rake aborted!
ActiveRecord::StatementInvalid: PG::Error: ERROR:  must be owner of database testp00
: DROP DATABASE IF EXISTS "testp00"
/Users/snailwalker/.rvm/gems/ruby-2.0.0-p481/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `exec'
/Users/snailwalker/.rvm/gems/ruby-2.0.0-p481/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
/Users/snailwalker/.rvm/gems/ruby-2.0.0-p481/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:435:in `block in log'
/Users/snailwalker/.rvm/gems/ruby-2.0.0-p481/gems/activesupport-(required)>'
/Users/snailwalker/.rvm/gems/ruby-2.0.0-p481/gems/activerecord-4.0.2/lib/active_record/railties/databases.rake:370:in `block (3 levels) in <top (required)>'
Tasks: TOP => db:test:load => db:test:purge
(See full trace by running task with --trace)

psql：

   snailwalker=# \l
                                     List of databases
       Name        |    Owner    | Encoding | Collate | Ctype |      Access privileges      
-------------------+-------------+----------+---------+-------+-----------------------------
 devep00           | snailwalker | UTF8     | C       | UTF-8 | 
 myapp_development | snailwalker | UTF8     | C       | UTF-8 | 
 myapp_test        | snailwalker | UTF8     | C       | UTF-8 | 
 postgres          | snailwalker | UTF8     | C       | UTF-8 | 
 snailwalker       | snailwalker | UTF8     | C       | UTF-8 | 
 template0         | snailwalker | UTF8     | C       | UTF-8 | =c/snailwalker             +
                   |             |          |         |       | snailwalker=CTc/snailwalker
 template1         | snailwalker | UTF8     | C       | UTF-8 | =c/snailwalker             +
                   |             |          |         |       | snailwalker=CTc/snailwalker
 testp00           | snailwalker | UTF8     | C       | UTF-8 | 
(8 rows)

databse.yml：

  development:
  adapter: postgresql
  encoding: unicode
  database: devep00
  pool: 5
  username: taouan
  password:

test:
  adapter: postgresql
  encoding: unicode
  database: testp00
  pool: 5
  username: taouan
  password:

萤火虫

感谢RAJ提醒我检查database.yml文件，我以某种方式为用户名设置了一个值，但我忘记了它，默认情况下它应该为nil，所以我删除了用户名：“ taouan”，然后运行了bundle exec rake test:prepare它。另一种方法是ALTER DATABASE testp00 OWNER TO "taouan"

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。