hi there,
I installed postgreSQL 7.3.2 on RedHat 8.0 successfully, and created a database and an user. I also added these lines
in the pg_hba.conf file.

local mydb myuser password
host mydb myuser password
host mydb myuser password

When i tried to get connected to my application with this setting, i got the following error

java.sql.SQLException: FATAL: Password authentication failed for user "myuser"

I observed that, unlike the lower versions of postgrSQL, the db user's password is stored in
encrypted form (i think md5) in the pg_shadow table. Is this the reason for the problem ?
I also gave 'md5' instead of 'password', but didn't work
(only 'trust' works !!! )

please let me know the solution to the above problem at the earliest,
thanks in advance,