Re: [GENERAL] password for postgres
On 2009-02-13, Kusuma Pabba kusu...@ncoretech.com wrote: i don't know y am i getting this problem when i try to start off postgres it asks me for password: what OS. what command are you using? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] password for postgres
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You do not want to use the keyword encrypted. To get in, go to your pg_hba file and set the security level to trust for your account. Then go in as postgres without a password and change it by: alter role postgres with password 'welcome'; ALTER USER postgres with encrypted password 'your_password'; ALTER USER postgres with encrypted password 'welcome'; but it is not accepting both the passwords i am getting incorrect password after three trials it is returning back to command prompt -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkmXsSQACgkQjDX6szCBa+poGACgxKo0aHk+7+XzsdlOLVnPD0zY aJ8An0ArIlUvz19M3um4HS7wS1BW6ZC3 =sbx/ -END PGP SIGNATURE- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] password for postgres
i don't know y am i getting this problem when i try to start off postgres it asks me for password: i did not set any password as such except that when the first day i used template, i ahve used the below two statements ALTER USER postgres with encrypted password 'your_password'; ALTER USER postgres with encrypted password 'welcome'; but it is not accepting both the passwords i am getting incorrect password after three trials it is returning back to command prompt when i have used select * from pg_shadow; then i got md5d31faa0b92fad4e2d8e4af34a30f890b though i use this i am not able to acess i don't know what to do with this issue can any one shed light on me by explaining me what was the mistake i did or which password to use thanks for any help Regards kusuma.p -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] password for postgres
Kindly let me know two things to answer you. First, Are you trying to start postgres service or psql prompt? second, what OS is in your use.
Re: [GENERAL] password for postgres
On Friday 13 February 2009 2:18:32 am Kusuma Pabba wrote: i don't know y am i getting this problem when i try to start off postgres it asks me for password: Are trying to start the Postgres program or are you trying to connect to an already running server? i did not set any password as such except that when the first day i used template, i ahve used the below two statements ALTER USER postgres with encrypted password 'your_password'; ALTER USER postgres with encrypted password 'welcome'; If you did it that order then your password for connecting should be 'welcome'. User/role information is cluster wide. If you entered the above to access the template then it is in effect for all databases in the cluster. Are you connecting as the user postgres or another user? but it is not accepting both the passwords i am getting incorrect password after three trials it is returning back to command prompt What is the error message that you are getting? Have you set up the pg_hba.conf file correctly? See http://www.postgresql.org/docs/8.3/interactive/client-authentication.html for more information. when i have used select * from pg_shadow; then i got md5d31faa0b92fad4e2d8e4af34a30f890b I am assuming this is for the user postgres. though i use this i am not able to acess i don't know what to do with this issue can any one shed light on me by explaining me what was the mistake i did or which password to use thanks for any help Regards kusuma.p -- Adrian Klaver akla...@comcast.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Password for postgres
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 QA for great tips from Yahoo! Answers users.
Re: [GENERAL] Password for postgres
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 QAhttp://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=asksid=396546091for great tips from Yahoo! Answershttp://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=asksid=396546091users.