title: Postgres createuser wants a password (not my system password)
body: <p>I installed the latest version of postgres on OS X Lion using homebrew. The path is correct:</p>
  
  <pre><code>$ which postgres
  /usr/local/bin/postgres
  $ which psql
  /usr/local/bin/psql
  </code></pre>
  
  <p>and brew doctor is happy. However, when I try to create a user, this happens: </p>
  
  <pre><code>$ createuser myuser
  Password:
  createuser: could not connect to database postgres: FATAL:  password authentication failed for user &lt;$USER&gt;
  </code></pre>
  
  <p>The password is definitely not my regular user password and I have no idea how to find out what it's supposed to be. It's possible that I used homebrew to install a different version of postgres some time ago while installing a bunch of other stuff, but I don't recall. I did notice a different version of 'postgresql' that was installed alongside the new version of 'postgres', which I removed. </p>
  
  <p>Don't know if this is a clue, but when I do this:</p>
  
  <pre><code>$ sudo su - postgres
  </code></pre>
  
  <p>The path to psql (but not postgres) is no longer correct: </p>
  
  <pre><code>postgres$ which postgres
  /usr/local/bin/postgres
  postgres$ which psql
  /usr/bin/psql
  </code></pre>
  
  <p>Might be something simple. Would appreciate any help. Thanks!</p>
  
  <pre><code>Mac OS X Lion 10.7.5
  homebrew 0.9.3
  postgres 9.2.1
  </code></pre>