title: Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails
body: <p>I'm getting the error:</p>
  
  <pre><code>FATAL: Peer authentication failed for user "postgres"
  </code></pre>
  
  <p>when I try to make postgres work with Rails. </p>
  
  <p>Here's my <a href="http://pastebin.com/4V1sMS01" rel="noreferrer"><code>pg_hba.conf</code></a>, my <a href="http://pastebin.com/mS0G6Srp" rel="noreferrer"><code>database.yml</code></a>, and a <a href="http://pastebin.com/bXg1Pkr5" rel="noreferrer">dump of the full trace</a>.</p>
  
  <p>I changed authentication to md5 in pg_hba and tried different things, but none seem to work. </p>
  
  <p>I also tried creating a new user and database as per <a href="https://stackoverflow.com/questions/9987171/rails-3-2-fatal-peer-authentication-failed-for-user-pgerror">Rails 3.2, FATAL: Peer authentication failed for user (PG::Error)</a></p>
  
  <p>But they don't show up on pgadmin or even when I run <code>sudo -u postgres psql -l</code>.</p>
  
  <p>Any idea where I'm going wrong?</p>