ruby-on-rails - ActiveRecord::Base.establish_connection 与 AWS 上的 postgresql

Question

当我像这样配置我的 database.yml 时:

default: &default
  adapter: postgresql
  encoding: utf8
  pool: 5
  timeout: 5000

production:
  <<: *default
  host: my_db_address
  port: 5432
  database: my_db_name
  username: my_db_user_name
  password: my_db_password

< test and development ommited >

当我这样建立连接时:

ActiveRecord::Base.establish_connection

它说 ActiveRecord::AdapterNotSpecified - 'production'

如果我这样做，它会起作用:

ActiveRecord::Base.establish_connection(
    {:adapter => 'postgresql',
     :database => 'my_db_name',
     :host => 'my_db_address',
     :port => '5432',
     :username => 'my_db_user_name',
     :password => 'my_db_password'}
)

我宁愿从 database.yml 加载配置。我该怎么做？

我在 Rails 4.2.1 和 Postgres 9.4 上

Answer 1

这是工作代码:

db_config = YAML.load_file('config/database.yml')
ActiveRecord::Base.establish_connection(db_config['production'])