alter user password does NOT change password

[motl3y]

I am using postgresql 8.0
I tried to change the password for postgres (the super user),
using the alter command, didn't seem to work... all the research i've done showed me that this should work, steps i took:
- logged in as root
- su postgres
- psql -d testdb -U postgres
- ALTER USER postgres WITH PASSWORD 'pg_password';
(prompted 'ALTER USER')

Exited the terminal, logged back in to see if if the new password works... nothing doing. After entering this command:
"psql -d testdb -U postgres"
It didn't prompt me to enter a password...
Currently I can login as postgres with NO password at all (or i can enter just about anything in the password field for this username, it'll allow me in)
Thank's in advance.

- motl3y

 

[stoolpigeon]

I would check pg_hba.conf and make sure that it is going to require a password.