> > After I Updatded my pgsql from 7.3 to 7.4.6 in debian with > "aptitude", I > > found that my admin user account's password has gone--everytime when > I > > login into psql, I don't need type my password any more, and every > > other user account too. > > Have you looked at pg_hba.conf? See the "Client Authentication" > chapter in the documentation for details.
Thanks for your help! I have modified my pg_hda.conf as the DOC said, and I can login with my password use "psql" in terminal. But it still remains a problem that I can't acess to my database through webclients such as PhpPgAdmin and my other phpclient. What's wrong then? Thank you again! -- Wang Jun@ Atmos. Dep. of Nju Nanjing Jiangsu China. GNU is Not Unix, BSD is Powerful, Ada is Beautiful, Nju is Graceful.
#This is my admin user account local all pgAdminWang password host all pgAdminWang 127.0.0.1 255.255.255.0 password host all pgAdminWang 192.168.0.114 255.255.255.0 password #this is Common user account local all wang password host all wang 127.0.0.1 255.255.255.255 password # System defaults, haven't changed yet. local all postgres ident sameuser local all all ident sameuser host all all 127.0.0.1 255.255.255.255 ident sameuser host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser host all all ::ffff:127.0.0.1/128 ident sameuser host all all 0.0.0.0 0.0.0.0 reject
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
