title: Trying to access psql after dropping a user but still got asked for entering password for the dropped user
body: <p>initially I have </p>
  
  <pre><code>Role name  |                         Attributes                         | Member of 
  ------------+------------------------------------------------------------+-----------
   hezhenghao | Create DB                                                  | {}
   postgres   | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
  </code></pre>
  
  <p>and I typed </p>
  
  <pre><code>postgres=# REASSIGN OWNED BY hezhenghao to postgres
  postgres-# ;
  REASSIGN OWNED
  postgres=# REASSIGN OWNED BY hezhenghao to postgres;                                                                                                 REASSIGN OWNED
  postgres=# DROP OWNED BY hezhenghao;
  DROP OWNED
  postgres=# DROP USER hezhenghao;
  DROP ROLE
  </code></pre>
  
  <p>Now there is only one user </p>
  
  <pre><code>postgres=# \du
                                     List of roles
   Role name |                         Attributes                         | Member of 
  -----------+------------------------------------------------------------+-----------
   postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
  </code></pre>
  
  <p>However when I type <code>psql</code> in terminal, I still got asked to <code>Password for user hezhenghao:</code>
  and then I would end up with <code>psql: FATAL:  password authentication failed for user "hezhenghao"</code></p>
  
  <p>I am new to <code>postgres</code> so I don't really understand what's going on here. Can someone help me with this?</p>