title: Login to PostgreSQL using md5 encrypted password and not plaintext password
body: <p>I have created an user using md5 encrypted password as follows:</p>
  <pre><code>create user testuser with encrypted password 'md54ca03099a7cd3945e0260801ff5972a3';
  </code></pre>
  <p>The encrypted password is combination of &quot;md5&quot; + md5(password+username)</p>
  <pre><code>password=test
  username=testuser
  </code></pre>
  <p>Added entry for testuser in pg_hba.conf file with md5 method</p>
  <p>Now I am trying to login using above created user as follows:</p>
  <pre><code>psql -d dbexpress -U testuser
  </code></pre>
  <p>It prompts for password. I have provided above encrypted password so it is giving me error as:</p>
  <pre><code>psql: FATAL:  password authentication failed for user &quot;testuser&quot;
  </code></pre>
  <p>But I am able to login to postgresql using plaintest password &quot;test&quot;.</p>