Re: Explanation of pg_authid.rolpassword - Mailing list pgsql-docs

From Josh Kupershmidt
Subject Re: Explanation of pg_authid.rolpassword
Date
Msg-id AANLkTimjcoES667kJshbwaiu6DCaaGYFu1e453nrDb+k@mail.gmail.com
Whole thread Raw
In response to Re: Explanation of pg_authid.rolpassword  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Explanation of pg_authid.rolpassword  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-docs
On Sun, Sep 12, 2010 at 8:36 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Thu, Sep 2, 2010 at 11:06 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> This seems a bit long-winded to me.  How about just changing the
> column description to something like this:
>
> Either the user's unencrypted password (if the UNENCRYPTED option was
> used when creating the role or if password_encryption is off), or the
> string 'md5' followed by a 32-character hexadecimal md5 hash of the
> user's password.  NULL if no password.

I agree my explanation might have been a tad lengthy. But the md5 hash
is of password plus username, not just password. This does seem to
cause confusion; maybe we could leave the example password hashing in
as a footnote on that page?

Josh

pgsql-docs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Explanation of pg_authid.rolpassword
Next
From: Robert Haas
Date:
Subject: Re: Explanation of pg_authid.rolpassword