Hello,
Although I have many years of database experience, I am new to postgresql.
My system is a 64 bit windows 10 laptop. I just downloaded and installed postgresql. The installation completed without any errors or complaints.
I was able to create a database with "createdb -U postgres mydb"
Now I want to be able to create a non administrator user so I tried the following:
createuser --password -U postgres myusername
I was prompted for the password for "postgres" but I was not prompted for the password for the new user.
I tried to run a createdb command for the new user but password authentication failed.
Why was I not prompted for a password during the creation of the new user?