Rails 3 PostgreSQL sample config

database.yml

development:
  adapter: postgresql
  encoding: unicode
  database: applicationname_development
  host: localhost
  pool: 5
  username: postgres
  password: postgres

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

production:
  adapter: postgresql
  encoding: unicode
  database: applicationname_production
  host: localhost
  pool: 5
  username: postgres
  password: postgres