From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Terry Yapt <pgsql(at)technovell(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: passwords in pg_shadow (duplicate). |
Date: | 2002-12-05 09:35:30 |
Message-ID: | 3DEF1DE2.264D5156@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-12-05 09:35:58 | Re: Postgresql -- initial impressions and comments |
Previous Message | 帅猛 | 2002-12-05 08:31:02 | install postgresql on cygwin error |