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

Re: What is a password for?

From: Weiwei Guo <wwguocn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: What is a password for?
Date: 2008-03-17 05:36:36
Message-ID: 47DE0364.60806@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Abdelkader BoudihDate: 2008-03-17 12:56:33
Subject: Re: What is a password for?
Previous:From: Tom LaneDate: 2008-03-17 05:34:25
Subject: Re: What is a password for?

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