title: Postgresql or psql 'rails db' password error
body: <p>I am trying to prompt the psql interface to try to create a database, actually following from Dr. Hartl's tutorials <a href="http://ruby.railstutorial.org/book/ruby-on-rails-tutorial?version=3.2" rel="nofollow">http://ruby.railstutorial.org/book/ruby-on-rails-tutorial?version=3.2</a>.</p>
  
  <p>I created the project with:</p>
  
  <pre><code>rails new postgr_ --database=postgresql
  </code></pre>
  
  <p>I added passwords to the database.yml file:</p>
  
  <pre><code>development:
    adapter: postgresql
    encoding: unicode
    database: postgr__development
    pool: 5
    username: postgr_
    password: 12345
  
  test:
    adapter: postgresql
    encoding: unicode
    database: postgr__test
    pool: 5
    username: postgr_
    password: 12345
  
  production:
    adapter: postgresql
    encoding: unicode
    database: postgr__production
    pool: 5
    username: postgr_
    password: 12345
  </code></pre>
  
  <p>I then enter into terminal:</p>
  
  <pre><code>$ rails db
  </code></pre>
  
  <p>And I get the following error after entering my password:</p>
  
  <pre><code>psql: FATAL:  password authentication failed for user "postgr_"
  </code></pre>
  
  <p>I've been going at this a good part of yesterday and all day today and was unable to work around this. I may very well be missing something fundamental, if you spot it please let me know. Thank you!</p>