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 00:25:26
Message-ID: 47DDBA76.2020604@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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'?

Micah Yoder :
> On Sunday 16 March 2008 12:31:40 am Weiwei Guo wrote:
>> I cannot understand the mechanism for password. Is it a bug?
>
> Check your pg_hba.conf file.  I suspect that for LOCAL connections you have 
> specified TRUST "authentication".
>
> If you want to enforce passwords you would change TRUST to MD5.
>
>

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-03-17 00:55:56
Subject: Re: What is a password for?
Previous:From: Andrej Ricnik-BayDate: 2008-03-16 05:49:37
Subject: Re: What is a password for?

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