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

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

2006-03-28 Thread Martin Pitt
Hi lmyho, lmyho [2006-03-28 0:17 -0800]: > 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"

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

2006-03-28 Thread Adrian Maier
On 3/28/06, lmyho <[EMAIL PROTECTED]> 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

[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