title: rake db:create:all => FATAL: password authentication failed for user "foo"
body: <p>Trying to setup a postgresql db for the first time. I'm using <a href="http://railscasts.com/episodes/342-migrating-to-postgresql/" rel="nofollow">this</a> railscast. After many hours of frustrating issues, I got as far as rake db:create:all. Now I get the error:</p>
  
  <pre><code>password authentication failed for user "pgtest"
  </code></pre>
  
  <p>Here is my pg_hba.conf</p>
  
  <pre><code># TYPE  DATABASE        USER            ADDRESS                 METHOD
  
  # "local" is for Unix domain socket connections only
  local   all             all                                     trust
  # IPv4 local connections:
  host    all             all             127.0.0.1/32            trust
  # IPv6 local connections:
  host    all             all             ::1/128                 trust
  </code></pre>
  
  <p>Here is my database.yml</p>
  
  <pre><code>development:
    adapter: postgresql
    encoding: unicode
    database: pgtest_development
    pool: 5
    username: pgtest
    password: password
  
  test:
    adapter: postgresql
    encoding: unicode
    database: pgtest_test
    pool: 5
    username: pgtest
    password: password
  </code></pre>
  
  <p>I tried it first with no password and it gives the error:</p>
  
  <pre><code>fe_sendauth: no password supplied
  </code></pre>
  
  <p>What am I doing wrong? Thanks :)</p>