title: PG::ConnectionBad FATAL: role "myapp" does not exist
body: <p>I'm able to type rails s without any issues inside of an app using postgres.app on Mac using postgres.app, however, when I go to localhost:3000 it gives me this error:</p>
  
  <pre><code>PG::ConnectionBad
  FATAL: role "myapp" does not exist
  </code></pre>
  
  <p>I thought at first the problem was the database.yml file but heroku docs even say to have it the way it is: <a href="https://devcenter.heroku.com/articles/getting-started-with-rails4">https://devcenter.heroku.com/articles/getting-started-with-rails4</a></p>
  
  <pre><code>development:
  adapter: postgresql
  encoding: unicode
  database: myapp_development
  pool: 5
  username: myapp
  password:
  </code></pre>
  
  <p>Here is my full log. I've seen similar issues but they only vaguely relate to this.</p>
  
  <p>snippet:</p>
  
  <pre><code>Started GET "/" for 127.0.0.1 at 2014-03-25 16:48:31 -0600
  
  PG::ConnectionBad (FATAL:  role "myapp" does not exist
  ):
    activerecord (4.0.2) lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `initialize'
    activerecord (4.0.2) lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `new'
    activerecord (4.0.2) lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `connect'
    activerecord (4.0.2) lib/active_record/connection_adapters/postgresql_adapter.rb:548:in `initialize'
    activerecord (4.0.2) lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
    activerecord (4.0.2) lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection'
    activerecord (4.0.2)  lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout'
    /Users/johncurry/.rvm/rubies/ruby-2.0.0-p247/lib/ruby/2.0.0/monitor.rb:211:in `mon_synchronize'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
    /Users/johncurry/.rvm/rubies/ruby-2.0.0-p247/lib/ruby/2.0.0/monitor.rb:211:in `mon_synchronize'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
    activerecord (4.0.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in 
  </code></pre>
  
  <p>any suggestions?</p>