title: psql: FATAL: password authentication failed for user "postgres"
body: <p>I am using Windows 10 and have just installed PostgreSQL 10.4.
  Now my superuser is postgres and I have to create a new user. I used the following command on cmd :-</p>
  
  <p><code>psql -U postgres -c "CREATE ROLE gautam LOGIN NOSUPERUSER INHERIT CREATEDB CREATEROLE;" mydb</code></p>
  
  <p>and the error is </p>
  
  <p><code>C:\Users\Gautam Jajoo&gt;psql -U postgres
  psql: FATAL:  password authentication failed for user "postgres"
  password retrieved from file "C:\Users\Gautam Jajoo\AppData\Roaming/postgresql/pgpass.conf"</code></p>
  
  <p>Can anyone tell the possible solution for it !!</p>