On 3/28/06, lmyho <lm_yho@yahoo.com> wrote:
> Dear All,
>
> 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??
You could try to change the ident method to trust (in pg_hba.conf). This
should allow you to login.
Then, set the password of the postgres user (alter user postgres with password
'blabla1212' ; ). Then you could change the ident method back to md5 .
Adrian Maier