title: psql fatal role does not exist
body: <p>I recently installed the latest version of Ubuntu and I'm not used to it yet. I had several problems connecting PostgreSQL with pgadmin3.</p>
  
  <p>I tried to follow several tutorials to create a localhost server which I can use in pgadmin3. I didn't really hit the mark and I think I made it worse by installing, uninstalling, installing, uninstalling, trying answers I found... At this point I'm not sure my PostgreSQL is clean. It could be possible that I have two PostgreSQL installed, once again, I'm not sure. I tried to uninstall it but I had an error which basically said PostgreSQL wasn't in sudo.</p>
  
  <p>The thing is I now have this error running psql in the console:</p>
  
  <pre class="lang-none prettyprint-override"><code>$psql
  psql: FATAL: role "user" does not exist 
  </code></pre>
  
  <p>I can't find the <code>pg_hba.conf</code> and at this point I'm too afraid to make things even worse by trying following any other posts.</p>
  
  <p>How could I make this work?</p>