PostgreSQL database configuration with PostGIS support for Ruby on Rails

database.yml

default: &default
  adapter: postgis
  encoding: utf8
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  host:  <%= ENV['PG_HOSTNAME'] %>
  timeout: 5000

development:
  <<: *default
  database: <%= ENV['PG_DATABASE_DEV'] %>
  username: <%= ENV['PG_USERNAME_DEV'] %>
  password: <%= ENV['PG_USERPASSWORD_DEV'] %>
  reconnect: false

test:
  <<: *default
  database: <%= ENV['PG_DATABASE_TEST'] %>
  username: <%= ENV['PG_USERNAME_TEST'] %>
  password: <%= ENV['PG_USERPASSWORD_TEST'] %>
  reconnect: false