Re: Re: Proposal for encrypting pg_shadow passwords

> Bruce Momjian writes:
>
> >     two new files (backend/libpq/md5.c and include/libpq/md5.h)
> >         which implement MD5 encryption (from Vince with cleanups)
>
> How about adding these to backend/utils/adt, so we can provide an SQL md5
> function, just for completeness.  (Might be useful to manually verify the
> passwords in pg_shadow or something.)  There's already code for this in
> contrib/pgcrypto, btw.

Uh, yea, I guess I could do that.  However, I need to move on to the SCM
creditials patch if we want that in 7.2.  In fact, because the md5 patch
didn't make anyone ill, I am going to apply it now so I can start on the
SCM stuff.  I can't figure out how to keep them a separate patches
because they overlap so much.

Also, should we be adding it if it is already in pgcrypto with other
nice items?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026