Skip site navigation (1) Skip section navigation (2)

Re: What is a password for?

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: (view raw, whole thread or download thread mbox)
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';


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

In response to

pgsql-novice by date

Next:From: G. J. WalshDate: 2008-03-18 22:25:15
Subject: Database Classes and prepared statements
Previous:From: Weiwei GuoDate: 2008-03-17 05:36:36
Subject: Re: What is a password for?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group