Thread: Passwords not working

Passwords not working

From
John Goerzen
Date:
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