I am trying to get Postgres to use SHA as the password hash algorithm instead of MD5. This is a security requirement. I am running PostgreSQL 8.4 on a Red Hat Linux platform. I have installed pgcrypto and ran pgcrypto.sql. I also created a function SHA-256. The function looks like:
CREATE OR REPLACE FUNCTION sha256(bytea) returns text AS $$
SELECT encode(digest($1, 'sha256'), 'hex')
$$ LANGUAGE SQL STRICT IMMUTABLE;
I then created a new user. Then I queried pg_shadow and the encrypted password still has md5 at the beginning of the hash. How do I get postgres to use SHA-256?
Any help would be greatly appreciated.
pgsql-admin by date
|Next:||From: Lonni J Friedman||Date: 2012-06-07 17:41:36|
|Subject: pg_basebackup blocking all queries with horrible performance|
|Previous:||From: hari.fuchs||Date: 2012-06-07 07:47:21|
|Subject: Re: Can schemas be ordered regarding their creation time ?|