PostgreSQL not stsrt!:( -Re: [HACKERS] Please help, pgAdmin3 on Debian!

2006-03-29 Thread lmyho
>> 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

Re: [HACKERS] Please help, pgAdmin3 on Debian!

2006-03-28 Thread lmyho
> 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 . > Hi Adrian, Thank you for help!! I

[HACKERS] Please help, pgAdmin3 on Debian!

2006-03-28 Thread lmyho
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 th