Hi,
First, please CC me any reply to this message since I'm not on the list at
the moment.
Here's the situation:
I have run:
alter user imp with password foo;
(with the real password there...)
pg_hba.conf has:
host all 127.0.0.1 255.255.255.255 password
I'm running:
psql -u -h localhost imp
localhost resolves to 127.0.0.1
I type in the imp username and the password, and get back "User
authentication failed."
What am I doing wrong?
Also, there is a reference in create_user manpage to a non-existant pg_crypt
manpage. There's a pg_passwd utility with no manpage.
Thanks,
John