title: PostgreSQL : password authentication failed for user "sean"
body: <p>So I've looked around all over the place for an answer for this but I cannot find one anywhere.</p>
  
  <p>so I'm trying to setup a PostgreSQL database with nodeJS and I've installed pgadmin3 etc. </p>
  
  <p>here is my code </p>
  
  <pre><code>const express = require("express");
  const pg = require("pg");
  
  const connect = "postgres://sean:sean@localhost/karls"
  
  var pool = new pg.Pool(connect);
  
  router.route("/").get((req, res) =&gt; {
      pool.connect(function(err, client, done){
          if(err) return console.error("the error ocurred on: " + err);
          client.query("SELECT * FROM Recipe", function(err, result) {
              if(err) console.error(error);
              console.log(results)
              done();
          })
      })
  });
  </code></pre>
  
  <p>on my pgadmin3 I have a login role named sean as a super user so I don't know why it's not connecting I have the password correct but it keeps spitting out this error:</p>
  
  <blockquote>
    <p>error: password authentication failed for user "sean";</p>
  </blockquote>
  
  <p>I've been trying to fix this for ages if you need any more information let me know and ill update the question </p>
  
  <p>I've solved this problem :)</p>