title: psql: FATAL: password authentication failed for user
body: <p>I am trying to connnect to Postgresql 9.1 database on remote ubuntu 12.04  server  from my windows pc using putty.i have created user with password and when i run the command </p>
  
  <p>psql -U opentaps -d opentaps 
   (opentaps is the user i created for database opentaps)
  i get the below mesaage .
  psql: FATAL: password authentication failed for user "opentaps"
  i did try psql -U opentaps  -d opentaps -h localhost 
  but still same message after i supply the password .
  my password for the opentaps user is correct .also even when i try 
  psql -U postgres  -d postgres i get the same failure message .</p>
  
  <p>I made some changes in pg_hba.conf and it looks like this </p>
  
  <p><a href="https://docs.google.com/document/d/13ymGYj9e7YPFiaffwixLzsWJygp_OfBmgBi4Axgrg5A/edit?usp=sharing" rel="nofollow">https://docs.google.com/document/d/13ymGYj9e7YPFiaffwixLzsWJygp_OfBmgBi4Axgrg5A/edit?usp=sharing</a></p>
  
  <p>also in postgresql.conf i made the change by uncomenting
  listen_addresses = '*'
  i know i am missing something here .need your help to know what else i need to change to connect to the server.</p>
  
  <p>thanks for your help</p>