Wei Weng <wweng(at)kencast(dot)com> 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