Yes, I set a password. I'm sure that I used the right password for
'postgres'. I can su to 'postgres' with it.
~ $ createuser -U postgres -W test
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) y
Password: <i input password here>
createuser: could not connect to database postgres: FATAL: password
authentication failed for user "postgres"
Tom Lane 写道:
> Weiwei Guo <wwguocn@gmail.com> writes:
>> Thank you, Micah and Andrej. I change TRUST to MD5 and password works
>> mostly, but the user 'postgres' complains "
>> password authentication failed". Is there any special of 'postgres'?
>
> Did you set a password for it?
>
> regards, tom lane
>