title: Created a role in postgres database and no way to delete db or connect
body: <p>I installed postgresql on homebrew and I am unable to connect to db by running psql. The error I get is psql: FATAL:  role "some-role-name" does not exist. This is not a newly installed postgres and I believe I created a db on template1. Now I have no way of access db (creating a new db or deleting existing db with this role). If I try to add the role, I can't because the role does not exist.</p>
  
  <p>I tried uninstalling via homebrew but still getting the same error. This is a common issue for many people but it seems like most of the answers is just creating the missing role (i.e. createuser postgresql). I am not missing the role postgresql but rather some other role I probably created before. Also I can not create the role I am missing because the role does not exist.</p>
  
  <p>I deleted every single postgresql file/folder, uninstalled and reinstalled via brew and I still get this error with the exact same missing role.</p>