Dear All,
I am totally new to the PostgreSQL, and pgAdmin. I really need your help.
I just installed the PostgreSQL8.1 and pgAdmin3 on a Debian system, using the apt-get install command. Apparently, the initial database and the user "postgres" have also been automatically created during the installation.
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 of pgAdmin3, and changed the ident method in the pg_hba.conf file all to md5 to try again, but the database now ask me for the password!! which I couldn't figure out the passwd so I tried to created rules in the pg_ident.conf file to map both the ordinary user and root user od Debian system to postgres, and tried again. But still failed,:((( "ident authentication failed"again!!!:((( I've tried many times for all I could think and failed everytime failed:((( By the way each time before I try, I did "pg_ctl reload", and I could see the failure reason changed after I do reload.
I've sent mail to other list but no anwser back. I believe people in this group must know what's the reason and solution. So would you please help me? So if there is auto-created password for this auto-created postgres user, please anyone tell me what it is?? Also otherwise, how can I login using the "ident auth" method through pgAdmin3 (just locally) on the Debian system??
Any help would be greatly appreciated!!! Thank you so much for help!!!
leo
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates.