Ron Peterson <ron(dot)peterson(at)yellowbank(dot)com> writes:
> I'm having a bit of authentication trouble. I'm trying to use 'crypt'
> authentication. PostgreSQL 7.1beta5. My pg_hba.conf is as follows:
IIRC, you can't use crypt with a flat password file, you have to use
plain passwd authentication. (On a local connection there's not much
point in crypt anyway...)
BTW, it may help to look in the postmaster log; for many authentication
failures, the error message sent to the client is deliberately not
telling all. The message recorded in the log may have additional
details.
regards, tom lane