The command goes through fine, but the next time I log into postgres using
the command, >>psql mydb postgres >>it logs in, and doesnt ask me for a password at all. If I issue a command like,
This is because you have trust in pg_hba.conf file, change it to md5 so it asks for password every time you log in :)
psql mydb postgres mypwd
That is not the correct way, just as i mentioned change it to md5 and now when you do psql -d mydb -U postgres It will ask for a password. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 3/8/07, George Heller <[EMAIL PROTECTED]> wrote:
Hi all, I am using a postgres database, and want to set a password for the account. The default user name is 'postgres' and in order to set a password, I did an alter user as below, alter user postgres with password 'mypwd'; The command goes through fine, but the next time I log into postgres using the command, psql mydb postgres it logs in, and doesnt ask me for a password at all. If I issue a command like, psql mydb postgres mypwd it says, extra argument!!! I have checked the pg_shadow table, and it looks like the password has been set. I also have a trust entry for the database server that I am accessing it through, in the pg_hba.conf file. Any suggestions to get around this problem? Thanks! George ------------------------------ Need Mail bonding? Go to the Yahoo! Mail Q&A<http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091>for great tips from Yahoo! Answers<http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091>users.
