Hi,
We have a problem when logging in postgresql.
We are setting the user id and password using Create User command.
Now when we login the postgresql using
$psql -U username databasename
it does'nt prompt for the password but connects to the database.
The password is correctly set and we examined the pg_shadow table also
where it has been stored in the encrypted format. Please help us with
this.
Also when we log in the Psql with the small -u option it shows the option
is deprecated , use -U option , prompts for the user id and passsword but
never validates the password.
If someone else has faced this problem please help us out. This is very
ugently required.
Regards,
Deeps