Wei Weng <wweng@xxxxxxxxxxx> writes: > (As you can see, all 3 strings are different) > Why the difference? Is there something missing ?? Well, the password is actually supposed to be 'md5'||md5(passwd||user), thus: regression=# select md5('test_passwd' || 'test_user'); md5 ---------------------------------- c573460a3b356e4610bfae406e1d8a9f (1 row) So either you are mistyping the password at the client end, or there's something broken about the client-side code. regards, tom lane