Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: What is a p...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 8 Topic 3041 of 3323
 Post > Topic >>

Re: What is a password for?

by wwguocn@[EMAIL PROTECTED] (Weiwei Guo) Mar 17, 2008 at 08:25 AM

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

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice




 8 Posts in Topic:
What is a password for?
 wwguocn@[EMAIL PROTECTED]  2008-03-16 13:31:40 
Re: What is a password for?
 micah@[EMAIL PROTECTED]   2008-03-15 23:48:02 
Re: What is a password for?
 wwguocn@[EMAIL PROTECTED]  2008-03-17 08:25:26 
Re: What is a password for?
 tgl@[EMAIL PROTECTED] (T  2008-03-16 20:55:56 
Re: What is a password for?
 wwguocn@[EMAIL PROTECTED]  2008-03-17 13:36:36 
Re: What is a password for?
 tgl@[EMAIL PROTECTED] (T  2008-03-17 01:34:25 
Re: What is a password for?
 terminale@[EMAIL PROTECTE  2008-03-17 12:56:33 
Re: What is a password for?
 andrej.groups@[EMAIL PROT  2008-03-16 18:49:37 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Fri Dec 5 4:57:22 CST 2008.