Re: client authentication problem

Dave Vieglais <vieglais(at)ku(dot)edu> writes:
> Contents of pg_hba.conf:

> local all postgres ident sameuser
> local all all md5
> host all all 127.0.0.1 255.255.255.255 md5
> host all all 0.0.0.0 0.0.0.0 reject

> # tail /var/log/postgresql/postgresql.log
> LOG: redo record is at 0/6851324; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 61873; next OID: 28747
> LOG: database system is ready
> 2005-01-31 16:03:23 [31418] LOG: connection received: host=127.0.0.1 port=33377
> 2005-01-31 16:03:23 [31418] LOG: cannot use authentication method "crypt"
> because password is MD5-encrypted
> 2005-01-31 16:03:23 [31418] FATAL: Password authentication failed for user
> "test"

I'm fairly sure that this log entry is not possible unless the
postmaster found a pg_hba.conf entry specifying "crypt". Accordingly
I suspect pilot error. Perhaps you are looking at the wrong copy of
pg_hba.conf? Or maybe you changed the file and forgot to SIGHUP the
postmaster?

regards, tom lane