default: &default adapter: postgresql encoding: unicode pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> username: ********* password: ******** development: adapter: postgresql database: BlogApp_Rails_development username: ********* password: ******** encoding: unicode host: localhost pool: 5 test: adapter: postgresql database: BlogApp_Rails_test username: ********* password: ******** encoding: unicode host: localhost pool: 5 production: <<: *default database: BlogApp_Rails_production username: BlogApp_Rails password: <%= ENV["BLOGAPP_RAILS_DATABASE_PASSWORD"] %> Then: sudo -u postgres psql create role myapp with createdb login password 'password1';