Re: Please help, pgAdmin3 on Debian!

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