Ruby on Rails: Comment puis-je modifier database.yml pour postgresql?

Question

rails nouvelle application =>

Le fichier database.yml actuel est comme ça =>

 # SQLite version 3.x
#   gem install sqlite3
#
#   Ensure the SQLite 3 gem is defined in your Gemfile
#   gem 'sqlite3'
development:
  adapter: sqlite3
  database: db/development.sqlite3
  pool: 5
  timeout: 5000

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  adapter: sqlite3
  database: db/test.sqlite3
  pool: 5
  timeout: 5000

production:
  adapter: sqlite3
  database: db/production.sqlite3
  pool: 5
  timeout: 5000
 

J'ai besoin de modifier cela pour la base de données postgresql.

Comment puis-je faire ceci ?

Answer 1

Simplement:

 development:
  adapter: postgresql
  encoding: unicode
  database: blog_development
  pool: 5
  username: blog
  password:
 

Source: Configuration des applications Rails

Answer 2

development:
  adapter: postgresql
  encoding: utf8
  database: name
  username: hading
  password: my_db_password
  pool: 5 # not mandatory
  timeout: 5000 # not mandatory
  host: localhost
  port: your postgresql port number (5432 or 5433)

Answer 3

Comme Zabba dit que c'est

development:
  adapter: postgresql
  encoding: unicode
  database: blog_development
  pool: 5
  username: blog
  password:

Comme mentionné dans la Configuration des Applications Rails. Mais vous pourriez voulez être min_messages: WARNING, pour se débarrasser de la méchante de l'AVIS de messages postgresql vous donne lors d'une migration. Donc, mon database.yml entrée ressemble à ceci

development:
  adapter: postgresql
  encoding: unicode
  database: blog_development
  pool: 5
  username: blog
  password:
  min_messages: WARNING

Answer 4

 development:
  adapter: postgresql
  encoding: utf8
  database: name
  username: hading
  password: my_db_password
  host: localhost # not mandatory
  pool: 5 # not mandatory
  timeout: 5000 # not mandatory