致命：角色“根”不存在 [英] FATAL: role "root" does not exist

问题描述

我已经开始学习使用heroku，并试图执行
bundle exec rake db：create db：migrate 命令，我遇到以下错误，

 致命：角色root不存在
 /var/lib/gems/1.9.1/gems /activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:898:in`rescue in connect'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/ active_record / connection_adapters / postgresql_adapter.rb：888：在`connect'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `初始化'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in`new'
 / var / lib /gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in`postgresql_connection'
 /var/lib/gems/1.9.1/gems/activerecord- 4.1.8 / LIB / active_record / connection_adapters /抽象/ CONNEC tion_pool.rb：435：在`new_connection'中
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in`checkout_new_connection '
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in'acquire_connection'
 / var / lib /gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in`block in checkout'
 /usr/lib/ruby/1.9.1/ monitor.rb：211：在`mon_synchronize'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in`checkout '
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in`block in connection'
 / usr /lib/ruby/1.9.1/monitor.rb:211:in`mon_synchronize'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/ connection_pool.rb： 264：在`connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in`retrieve_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:113:in`retrieve_connection'
 /var/lib/gems/1.9.1/gems /activerecord-4.1.8/lib/active_record/connection_handling.rb:87:in`connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/ postgresql_database_tasks.rb：8：在`connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/postgresql_database_tasks.rb:17:in`create'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:88:in`create'
 /var/lib/gems/1.9 .1 / gems / activerecord-4.1.8 / lib / active_record / tasks / database_tasks.rb：102：在`block in create_current'
 /var/lib/gems/1.9.1/gems/activerecord-4.1。 8 / lib / active_record / tasks / database_tasks.rb：225：在每个current_conf中的block中配置'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:224:in`each'
 / var / lib / gems / 1.9.1 / gems / activerecord-4.1.8 / lib / active_record / tasks / database_tasks.rb：224：在'each_current_configuration'中
 /var/lib/gems/1.9.1/gems/activerecord-4.1 .8 / lib / active_record / tasks / database_tasks.rb：101：在`create_current'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/railties/databases。 rake：17：在< top（required）>'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task'块中（2级）。 rb：240：在`call'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:240:in`block in execute'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:235:in`each'
 /var/lib/gems/1.9.1/gems /rake-10.4.0/lib/rake/task.rb:235:in`execute'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task。 rb：179：在`block in invoke_with_call_chain'
 /usr/lib/ruby/1.9.1/monitor.rb:211:in`mon_synchronize'
 / var / lib / gems / 1.9.1 / gems / rake-10.4.0 / lib / rake / task.rb：172：在`invoke_with_call_chain'
 /var/lib/gems/1.9.1/gems/rake-10.4 .0 / lib / rake / task.rb：165：在`invoke'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:156： in'invoke_task'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in'block（2 levels）in top_level'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in`each'
 /var/lib/gems/1.9.1/gems /rake-10.4.0/lib/rake/application.rb:112:in`block in top_level'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/ application.rb：121：在`run_with_threads'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:106:in`top_level'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:84:in`block in run'
 /var/lib/gems/1.9.1 /gems/rake-10.4.0/lib/rake/application.rb:182:in`standard_exception_handling'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/ application.rb：79：在`run'
 / var / l ib / gems / 1.9.1 / gems / rake-10.4.0 / bin / rake：33：在< top（required）>'
 / usr / local / bin / rake：23：在'< main>'
中加载'
 / usr / local / bin / rake：23：无法为{adapter=>postgresql，encoding=> ;unicode，pool=> 5，database=>root} 
 FATAL：角色root不存在
 /var/lib/gems/1.9.1 /gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:898:in`rescue in connect'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/ lib / active_record / connection_adapters / postgresql_adapter.rb：888：在`connect'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:568 ：在`initialize'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in`new'
 / var /lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in`postgresql_connection'
 / var / lib / gems / 1.9.1 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / connection_pool.rb：435：在`new_connection'中
 /var/lib/gems/1.9.1/gems /activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in`checkout_new_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/ active_record / connection_adapters / abstract / connection_pool.rb：416：在'acquire_connection'中
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb ：351：在`block in checkout'
 /usr/lib/ruby/1.9.1/monitor.rb:211:in`mon_synchronize'
 /var/lib/gems/1.9.1/gems /activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in`checkout'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/ active_record / connection_adapters / abstract / connection_pool.rb：265：在`block in connection'
 /usr/lib/ruby/1.9.1/monitor.rb:211:in`mon_synchronize'
 / var / LIB /宝石/ 1.9。 1 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / connection_pool.rb：264：在'connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8 /lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in`retrieve_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb： 113：在`retrieve_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:87:in`connection'
 / var / lib / gems / 1.9.1 / gems / activerecord-4.1.8 / lib / active_record / tasks / postgresql_database_tasks.rb：8：在`connection'
 /var/lib/gems/1.9.1/gems/activerecord -4.1.8 / lib / active_record / tasks / postgresql_database_tasks.rb：17：在`create'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/ database_tasks.rb：88：在`create'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:102:in`block in create_current '
 /var/lib/gems/1.9.1/gems/act iverecord-4.1.8 / lib / active_record / tasks / database_tasks.rb：225：在'每个当前配置的块中'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record /tasks/database_tasks.rb:224:in`each'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:224:in` each_current_configuration'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:101:in`create_current'
 / var / lib / gems / 1.9.1 / gems / activerecord-4.1.8 / lib / active_record / railties / databases.rake：17：在< top（required）>'
 / var / lib / gems / 1.9.1 / gems / rake-10.4.0 / lib / rake / task.rb：240：在`call'
 /var/lib/gems/1.9.1/gems/rake-10.4 .0 / lib / rake / task.rb：240：在`block in execute'中
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb： 235：在`each'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:235:in`execute'
 / var / lib / gems / 1.9.1 / gems / rake-10.4.0 / lib / rake / task.rb：179：在`block in invoke_ with_call_chain'
 /usr/lib/ruby/1.9.1/monitor.rb:211:in`mon_synchronize'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/ lib / rake / task.rb：172：在`invoke_with_call_chain'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:165:in`invoke '
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:156:in`invoke_task'
 /var/lib/gems/1.9 .1 / gems / rake-10.4.0 / lib / rake / application.rb：112：在'block（2 levels）in top_level'
 /var/lib/gems/1.9.1/gems/rake- 10.4.0 / lib / rake / application.rb：112：在`each'中
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112 ：在`block in top_level'
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:121:in`run_with_threads'
 / var /lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:106:in`top_level'
 /var/lib/gems/1.9.1/gems/rake- 10.4.0 / lib / rake / application.rb：84：在`block in run'中
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb ：182：在`standard_exception_handling' 
 /var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:79:in`run'
 /var/lib/gems/1.9。 1 / gems / rake-10.4.0 / bin / rake：33：在< top（required）>'
 / usr / local / bin / rake：23：in`load'
 / usr / local / bin / rake：23：在< main>'
无法为{adapter=>postgresql，encoding=>unicode， pool=> 5，database=>ruby-getting-started_test} 
 rake aborted！ 
 ActiveRecord :: NoDatabaseError：FATAL：角色root不存在
运行$ bin / rake db：create db：migrate来创建数据库
 / var / lib / gems / 1.9.1 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / postgresql_adapter.rb：898：在`rescue in connect'中
 /var/lib/gems/1.9.1/gems/activerecord-4.1 .8 / lib / active_record / connection_adapters / postgresql_adapter.rb：888：在`connect'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter。 rb：568：在`initialize'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in`new'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41：in`postgresql_connection'
 /var/lib/gems/1.9.1 /gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in`new_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/ LIB / active_ record / connection_adapters / abstract / connection_pool.rb：445：in`checkout_new_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb ：416：在`acquire_connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in`block in checkout' 
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in`checkout'
 / var / lib / gems / 1.9.1 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / connection_pool.rb：265：在`block in connection'
 /var/lib/gems/1.9.1/gems /activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in`connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/ active_record / connection_adapters / abstract / connection_pool.rb：541：在'retrieve_connection'中
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/acti ve_record / connection_handling.rb：113：在'retrieve_connection'中
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:87:in`connection'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/migration.rb:909:in`initialize'
 /var/lib/gems/1.9.1 /gems/activerecord-4.1.8/lib/active_record/migration.rb:807:in`new'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/ migrate'
 /var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:34:in`block（2 levels）in< top（required）>'
任务：TOP => db：migrate 
（通过使用--trace运行任务来查看完整跟踪）
  

我有试图编辑schema.rb文件，但它是没有用的。我正在开发这个在Ubuntu上，请说明我在哪里出错

解决方案

问题是你没有ROLE您的本地计算机名为root。
在终端中运行：

  psql 
  

$ b $ p然后如果你在终端连接PostgreSQL：

pre $ CREATE ROLE root WITH密码'root'WITH CREATEDB LOGIN CREATEROLE CREATEUSER SUPERUSER;


或者只是将您的database.yml文件用户更改为存在有效密码的用户。 p>

PS

不要在您的终端中运行：

  heroku run rake db：创建
  

Heroku为您创建数据库，当你第一次将你的应用程序推送到Heroku的服务器。

但你可以运行：

  heroku run rake db：migrate 
  

I have started to learn using heroku and i was trying to execute bundle exec rake db:create db:migrate command, i have encountered the following errors,

FATAL:  role "root" does not exist
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:898:in `rescue in connect'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `connect'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `initialize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
/usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:113:in `retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:87:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/postgresql_database_tasks.rb:8:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/postgresql_database_tasks.rb:17:in `create'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:88:in `create'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:102:in `block in create_current'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:225:in `block in each_current_configuration'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:224:in `each'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:224:in `each_current_configuration'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:101:in `create_current'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:17:in `block (2 levels) in <top (required)>'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:240:in `call'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:240:in `block in execute'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:235:in `each'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:235:in `execute'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:172:in `invoke_with_call_chain'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:165:in `invoke'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:156:in `invoke_task'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in `block (2 levels) in top_level'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in `each'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in `block in top_level'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:121:in `run_with_threads'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:106:in `top_level'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:84:in `block in run'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:182:in `standard_exception_handling'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:79:in `run'
/var/lib/gems/1.9.1/gems/rake-10.4.0/bin/rake:33:in `<top (required)>'
/usr/local/bin/rake:23:in `load'
/usr/local/bin/rake:23:in `<main>'
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"root"}
FATAL:  role "root" does not exist
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:898:in `rescue in connect'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `connect'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `initialize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
/usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:113:in `retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:87:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/postgresql_database_tasks.rb:8:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/postgresql_database_tasks.rb:17:in `create'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:88:in `create'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:102:in `block in create_current'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:225:in `block in each_current_configuration'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:224:in `each'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:224:in `each_current_configuration'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/tasks/database_tasks.rb:101:in `create_current'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:17:in `block (2 levels) in <top (required)>'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:240:in `call'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:240:in `block in execute'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:235:in `each'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:235:in `execute'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:172:in `invoke_with_call_chain'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/task.rb:165:in `invoke'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:156:in `invoke_task'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in `block (2 levels) in top_level'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in `each'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:112:in `block in top_level'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:121:in `run_with_threads'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:106:in `top_level'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:84:in `block in run'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:182:in `standard_exception_handling'
/var/lib/gems/1.9.1/gems/rake-10.4.0/lib/rake/application.rb:79:in `run'
/var/lib/gems/1.9.1/gems/rake-10.4.0/bin/rake:33:in `<top (required)>'
/usr/local/bin/rake:23:in `load'
/usr/local/bin/rake:23:in `<main>'
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"ruby-getting-started_test"}
rake aborted!
ActiveRecord::NoDatabaseError: FATAL:  role "root" does not exist
Run `$ bin/rake db:create db:migrate` to create your database
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:898:in `rescue in connect'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `connect'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `initialize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:113:in `retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/connection_handling.rb:87:in `connection'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/migration.rb:909:in `initialize'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/migration.rb:807:in `new'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/migration.rb:807:in `up'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/migration.rb:785:in `migrate'
/var/lib/gems/1.9.1/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

i have tried to edit the schema.rb file but it is of no use. I am developing this on Ubuntu, please state where am i going wrong

解决方案

The problem is that you don't have ROLE on your local machine named root. Run this in a terminal:

psql

Then if you connect with PostgreSQL in your terminal:

CREATE ROLE root WITH PASSWORD 'root' WITH CREATEDB LOGIN CREATEROLE CREATEUSER SUPERUSER;

or just change in your database.yml file user to user, who exists with valid password.

P.S.

Don't run in your terminal:

heroku run rake db:create

Heroku creates for you database when you first time push your application to Heroku's servers.

But you can run:

heroku run rake db:migrate

这篇关于致命：角色“根”不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！