title: I forgot the password I entered during postgres installation
body: <p>I either forgot or mistyped (during the installation) the password to the default user of Postgres. I can't seem to be able to run it and I get the following error:</p>
  
  <pre><code>psql: FATAL:  password authentication failed for user "hisham"
  hisham-agil: hisham$ psql 
  </code></pre>
  
  <p>Is there anyway to reset the password or how do I create a new user with superuser privileges? </p>
  
  <p>I am new to Postgres and just installed it for the first time. I am trying to use it with Rails and I am running Mac OS X Lion.</p>