about password authentication

From: "Kwon, YongChul" <godslord(at)initech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: about password authentication
Date: 2000-01-24 13:00:25
Message-ID: 000301bf666a$fbeddea0$8525eecb@sigma
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi.

I compiled postgresql 6.5.3 with enable-hba.

I was created all database table succesfully.
create users, and update pg_shadow table with new password
successfully.

and I edit data/pg_hba.conf file like this

local all password
host all 127.0.0.1 255.255.255.255 password

but when i tried to connect database using psql,

%psql -u
Username: godslord
Password:

Connection to database 'godslord' failed.
Password authentication failed for user 'godslord'
%

I used password in pg_shadow. what's wrong?
(I update password column of pg_shadow table with
clear text password. like

update pg_shadow set password='PASSWORD'
where usename='userid';)

Browse pgsql-general by date

  From Date Subject
Next Message J. Roeleveld 2000-01-24 13:23:34 System requirements
Previous Message David Warnock 2000-01-24 12:19:39 Re: [GENERAL] CREATE TABLE AS