From: | George Heller <george(dot)heller(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Password for postgres |
Date: | 2007-03-08 06:41:41 |
Message-ID: | 409347.10830.qm@web56512.mail.re3.yahoo.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Johnston | 2007-03-08 06:46:07 | Re: Query help |
Previous Message | Madison Kelly | 2007-03-08 06:20:10 | Query help |