Postgres Pro
Downloads
Home   >   mailing lists

Thread: Password for postgres

Password for postgres

From
George Heller
Date:
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 for great tips from Yahoo! Answers users.

Re: Password for postgres

From
"Shoaib Mir"
Date:
>>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 <george.heller@yahoo.com> 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 for great tips from Yahoo! Answers users.