From: | Abdelkader Boudih <terminale(at)gmail(dot)com> |
---|---|
To: | Weiwei Guo <wwguocn(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: What is a password for? |
Date: | 2008-03-17 12:56:33 |
Message-ID: | 47DE6A81.6090305@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Use the *ALTER USER* to change the attributes and permissions of a
*PostgreSQL* database *user*.
In psql do :
# **ALTER USER postgres WITH PASSWORD 'your_password';
Regards
**
Weiwei Guo wrote:
> 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(at)gmail(dot)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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | G. J. Walsh | 2008-03-18 22:25:15 | Database Classes and prepared statements |
Previous Message | Weiwei Guo | 2008-03-17 05:36:36 | Re: What is a password for? |