Hi Rich, Thank you very much!! Have some further question: > Please can anyone help me here? I've been so frustrated.:( If there is > auto-created password > > for this auto-created postgres user, please anyone tell me what it is?? And > also otherwise, how > > can I log-in using the "ident auth" method?? > > If you just getting started with postgresql you will want to change the user > postgres ident to > "trust". How should I do this? The current auto-generated pg_hba.conf file read as: "local all postgres ident sameuser" on the first line, and the first line also after the # TYPE DATABASE....METHOD line. Do you mean I should change the "ident sameuser" at the end to "trust"? > > Then you should be able to log into postgresql using "psql -U postgres -d > template1" Should I login by this way from command line? THANK YOU!! leo __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
