如何修复:PG::连接错误:fe_sendauth:未提供密码

Question

我在Ruby on Rails文件夹中

$ 导轨服务器

WARNING: Nokogiri was built against LibXML version 2.9.4, but has dynamically loaded 2.8.0
** Invoke db:migrate (first_time)
** Invoke db:load_config (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:load_config
** Execute db:migrate
rake aborted!
PG::ConnectionBad: fe_sendauth: no password supplied
/Users/snowflake/.rvm/gems/ruby-2.5.1@global/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/snowflake/.rvm/gems/ruby-2.5.1/bin/ruby_executable_hooks:15:in `eval'
/Users/snowflake/.rvm/gems/ruby-2.5.1/bin/ruby_executable_hooks:15:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

日期库.yml

development:
adapter: postgresql
encoding: unicode
database: pcms_development
host: localhost
pool: 5
username: postgres
password: 
test:
adapter: postgresql
encoding: unicode
database: pcms_test
host: localhost
pool: 5
username: postgres
password: 

我刚刚将Postgresql Server，PGAdmin，Stack Tools安装到我的新Mac mini上。在我的MacBook上，我有一个postgresql服务器图标，显示了所有服务器。(这在我的Mac mini上丢失(

PGAdmin 正在运行。

本地主机：3000/欢迎/索引

Answer 1

作为您在application.yml文件中发布的示例，您没有指定密码：

test:
adapter: postgresql
encoding: unicode
database: pcms_test
host: localhost
pool: 5
username: postgres
password: 

您需要为您的 Postgres 用户设置一个密码，并将该密码放在您的 database.yml 上以解决问题