Thread: Problem with password authentication?

Problem with password authentication?

From
Scott Dowdle
Date:
Greetings from Billings, Montana.

Has anyone had any problem with password authentication?  I did a
pg_dumpall and the export and import seemed to go fine. If trust is in
the data/pg_hba.conf it works fine.  I verified that the database
contents between the original setup and the new 6.4.2 are the same.
When I add password to the data_pg_hba.conf (which works in 6.3.2 just
fine), I get an "authenication failure" error every time.  I turned the
log debugging level on to 3 and I can't seem to get any more
information... and am clueless as to why password based authentication
is failing.

Any help is appreciated.  Currently, I'm going to set up a postgresql on
a separate machine and build a database from scratch to see if I can get
password authentication working... and isolate if it was the database
transition that caused the problem.

Thanks in advance!

--
Scott Dowdle, Systems Programmer
Montana Communications Network
(406)254-9413 ext 354