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.
>
>