Dear All,<br /><br /> I am totally new to the PostgreSQL, and pgAdmin. I really need your help.<br /><br /> I just
installedthe PostgreSQL8.1 and pgAdmin3 on a Debian system, using the apt-get install command. Apparently, the initial
databaseand the user "postgres" have also been automatically created during the installation. <br /><br /> Which is
good. But I've got big trouble to login to this initial db by using this auto-created username "postgres" through
pgAdmin:((( The first try failed due to "Ident authentication failed", so I follow the suggestion on the pop-up window
ofpgAdmin3, and changed the ident method in the pg_hba.conf file all to md5 to try again, but the database now ask me
forthe password!! which I couldn't figure out the passwd so I tried to created rules in the pg_ident.conf file to map
boththe ordinary user and root user od Debian system to postgres, and tried again. But still failed,:((( "ident
authenticationfailed"again!!!:((( I've tried many times for all I could think and failed everytime failed:((( By the
wayeach time before I try, I did "pg_ctl reload", and I could see the failure reason changed after I do reload.<br
/><br/> I've sent mail to other list but no anwser back. I believe people in this group must know what's the reason
andsolution. So would you please help me? So if there is auto-created password for this auto-created postgres user,
pleaseanyone tell me what it is?? Also otherwise, how can I login using the "ident auth" method through pgAdmin3 (just
locally)on the Debian system??<br /><br /> Any help would be greatly appreciated!!! Thank you so much for help!!!<br
/><br/> leo<br /><br /><p><hr size="1" />New <a
href="http://us.rd.yahoo.com/mail_us/taglines/postman4/*http://us.rd.yahoo.com/evt=39666/*http://beta.messenger.yahoo.com">Yahoo!
Messengerwith Voice.</a> Call regular phones from your PC for low, low rates.