title: Should the database.yml be configured when testing locally for Heroku with foreman?
body: <p>Can someone explain to me what they do when they initialise a rails app locally with foreman (part of <a href="https://toolbelt.heroku.com/" rel="nofollow">Heroku toolbelt</a>) (using postgreSQL), destined to run on Heroku?</p>
  
  <p>I'm going by this guide: <a href="https://devcenter.heroku.com/articles/procfile#developing-locally-with-foreman" rel="nofollow">developing locally with foreman</a> and what I don't understand is if we are expected to specify database username and passwords or if foreman is supposed to handle it as Heroku itself does?</p>
  
  <p>This perplexes me a little as if we are supposed to modify the <code>database.yml</code> to hook it up to postgreSQL, then what is the point of using foreman instead of <code>rails server</code>?</p>
  
  <p>If it does handle it, how does it handle it, and how would I configure my <code>pg_hba.conf</code> to respect it? Something like <code>local all myuser trust</code>?</p>