title: postgres + how to delete the password for hive metastore and set new password
body: <p>we are working on HDP 2.6.5 cluster with ambari</p>
  <p>we want to change the password for hive , since we think we enter previously wrong password</p>
  <p>also from hive log we get:</p>
  <pre><code>Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user &quot;hive&quot;
  </code></pre>
  <p>so we try</p>
  <pre><code># su - postgres
  Last login: Mon Aug 31 15:27:30 UTC 2020 on pts/2
  -bash-4.2$ psql
  psql (9.2.24)
  Type &quot;help&quot; for help.
  
  postgres=# CREATE DATABASE hive;
  ERROR:  database &quot;hive&quot; already exists
  postgres=# CREATE USER hive WITH PASSWORD 'something';
  ERROR:  role &quot;hive&quot; already exists
  </code></pre>
  <p>but as we can see above we get - 'ERROR:  role &quot;hive&quot; already exists&quot;</p>
  <p>how to delete the current password and set the new password?</p>
  <p>reference - <a href="https://community.pivotal.io/s/article/How-to-find-the-Hive-metadata-store-password?language=en_US" rel="nofollow noreferrer">https://community.pivotal.io/s/article/How-to-find-the-Hive-metadata-store-password?language=en_US</a></p>