change p/w hashing

От:

"Jean-Yves F. Barbier" <12ukwn@gmail.com>

Дата:

17 июня 2011 г. в 04:56:54

Hi list,

Is there an easy way to discard Pg default md5 password hashing and replace it
by SHA256 (or SHA512) + salt?

JY
-- 
Psychiatry is the care of the id by the odd.

Re: change p/w hashing

От:

Josh Kupershmidt <schmiddy@gmail.com>

Дата:

21 июня 2011 г. в 18:48:34

On Fri, Jun 17, 2011 at 3:56 AM, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> Is there an easy way to discard Pg default md5 password hashing and replace it
> by SHA256 (or SHA512) + salt?

I doubt there's an "easy way". First, the md5 authentication of
clients via libpq would be broken. Second, AFAIK the only hash algo
built into core is MD5 (SHA-256 and friends are in
./contrib/pgcrypto).

Josh