Re: passwords in pg_shadow (duplicate).

Bruce Momjian wrote:
>
> Good catch.  Seems like a bug.  I assumed we still want to support
> 'password' even though pg_shadow contains MD5 encrypted passwords.  Is
> that correct?  (We can't support crypt in those cases.)
>
> The following patch fixes this.  I need to review it later, but we could
> apply to 7.3.1.  I assume there are still some interfaces that don't
> support md5 or crypt and we will need this patch to continue supporting
> them, though I am sure there are some out there that want 'password' to
> go away.

Honestly I don't understand your intention.
For example, if some one would like to use
crypt authentication what should he do ?
Certainly he can store a plain password using
'with unencrypted password ....'. But pg_dump
would dump it as 'with password ....' and as
a result the password would be restored as MD5
encrypted password by default.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/