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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
