Thread: ident authentication failed for user postgres.
dear friends, thanks devrim. the yum install worked fine. however i can not connect to the database i made in postgresql-8.0.3-1 using pgadminIII. it posted ident authentication failed for user postgres. i tried to edit the pg_hba.conf file and added host all all 192.168.9.0.0/24 md5 under IPv4 local connections as suggested in the message in pgadminIII, but still it did not connect. what would be the best approach to remedy this problem. thanks for any advice. ramon __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
> i tried to edit the pg_hba.conf file and added host > all all 192.168.9.0.0/24 md5 under IPv4 > local connections as suggested in the message in > pgadminIII, but still it did not connect. There might be two possible problems. 1. I believe that when you change your pg_hba.conf you need to restart the server for the changes to take effect. 2. When you specify md5 authentication, both the user and the password must exist. So in this case, if you try to log in as postgres but have not specified a Postgresql password for postgres, you will be denied access. Notice: http://www.postgresql.org/docs/8.1/interactive/auth-methods.html#AUTH-PASSWORD http://www.postgresql.org/docs/8.1/interactive/sql-alteruser.html so... psql> ALTER USER postgres PASSWORD 'your_new_password' will allow you to authenticate your password using MD5. Regards, Richard Broersma Jr.
On 8/10/06, Ramon Orticio <rporticio@yahoo.com> wrote: > i tried to edit the pg_hba.conf file and added host > all all 192.168.9.0.0/24 md5 under IPv4 The subject line is speaking of ident authentication, but in pg_hba.conf you're using md5? Also, for ident authentication to work you MUST be connecting to postgres as the same OS user; Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm