barry kimelman <perlmaster56@gmail.com> writes:
> 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 think the option you wanted was
-P, --pwprompt assign a password to new role
This is different from --password, which prompts you for your *own*
password in order to connect to the server. Usually the only reason
to bother with that one is if you're writing some kind of script and
you would like it to prompt always, whether or not a password would
really be required.
regards, tom lane