title: Cloud9 postgres
body: <p>I am trying to set up a postgres database in a Rails app in Cloud9. </p>
  
  <p>I have followed the instructions here: <a href="https://docs.c9.io/setting_up_postgresql.html">https://docs.c9.io/setting_up_postgresql.html</a> and set up a database called cc_database.</p>
  
  <p>My database.yml file looks like this: </p>
  
  <pre><code>development:
    adapter: postgresql
    encoding: SQL_ASCII
    database: cc_database
    pool: 5
    username: postgres
    password: password
  </code></pre>
  
  <p>When I run rake db:setup I get the following error:</p>
  
  <pre><code> PG::ConnectionBad: FATAL:  Peer authentication failed for user "postgres"
  </code></pre>
  
  <p>I am quite new to all this, so any advice would be much appreciated.</p>