title: Windows: how can I set my PostgreSQL user to the superuser?
body: <p>I am trying to create a database using PostgreSQL 9.4. I type "psql" in the command prompt, and then it asks for a password. I provide the password I set during the installation, but it says the authentication failed. After checking online, I concluded that I need to be using the superuser, named "postgres", which is the system user whose password is the one I set during the installation.</p>
  
  <p>I am now trying to set PostgreSQL to this superuser. I spent a lot of time surfing the internet for a solution but wasn't able to solve the problem. I tried <code>postgres ALTER USER myuser WITH SUPERUSER</code> (I wrote that in the Windows command prompt), but it said that "alter" isn't recognized. Now, when I try to use PostgreSQL, <strong>my main problem is that I get the error: "role MYUSERNAME does not exist".</strong> (this is after I edited pg_hba.conf to make it not ask for a password)</p>